| exp/imp using Unix pipes across different hosts does not work [message #70307] |
Thu, 23 May 2002 00:57  |
Shyamal Thatte
Messages: 1
Registered: May 2002
|
Junior Member |
|
|
Tried exporting using Unix pipes as per the example in orafaq.net ... part of a large database migration.
Node1:
mknod node_1.dmp p
exp / file=node_1.dmp .......other options
Node2:
mknod node_2.dmp p
rsh Node1 dd if=node_1.dmp > node_2.dmp &
imp / file=node_2.dmp ...... other options
Both nodes are Solaris 8/Oracle 8i, Node2 has rsh access into Node1
Both sessions hang, without any activity.
Is there something am missing out here ??
Regards
Shyamal
|
|
|
|
| Re: exp/imp using Unix pipes across different hosts does not work [message #70310 is a reply to message #70307] |
Thu, 23 May 2002 07:39  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
This compresses the file on the fly:
/usr/sbin/mknod exp_prod_pipe.dmp p
cat exp_prod_pipe.dmp |compress > exp_prod_full.dmp.Z &
exp parfile=exp_prod.par userid=system/PASSWORD log=exp_prod_full.log file=exp_prod_pipe.dmp
Another method to uncompress:
mknod imp_prod_pipe.dmp p
uncompress < exp_prod_full.dmp.Z > imp_prod_pipe.dmp &
imp parfile=imp_db.par file=imp_prod_pipe.dmp log=imp_prod_full.log userid=system/PASSWORD
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
