Baber Amin
asked on
want to use expdp/impdp instead of exp/imp
Hi,
I want to use expdp/impdp instead of exp/imp as I came to know that its pretty fast. Due to very busy schedule I want to take you guys help that in having equivalent of the below exp/imp to convert in expdp/impdp
exp system/****@conn file=d:\exp.dmp log=d:\exp.log consistent=y owner=abcd
imp system/****@conn file='d:\exp.dmp' log='d:\imp.log' fromuser=abcd touser=abcd commit=Y
I want to use expdp/impdp instead of exp/imp as I came to know that its pretty fast. Due to very busy schedule I want to take you guys help that in having equivalent of the below exp/imp to convert in expdp/impdp
exp system/****@conn file=d:\exp.dmp log=d:\exp.log consistent=y owner=abcd
imp system/****@conn file='d:\exp.dmp' log='d:\imp.log' fromuser=abcd touser=abcd commit=Y
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks.
http://www.remote-dba.net/oracle_10g_new_features/network_link.htm
impdp admin2/market TABLES=customers,sales DIRECTORY=dpump1 NETWORK_LINK=chicago
http://www.techrepublic.com/article/import-data-via-a-network-link-in-oracle-10g/6132883