Link to home
Start Free TrialLog in
Avatar of Baber Amin
Baber AminFlag for Canada

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
Avatar of tangchunfeng
tangchunfeng

expdp hr/hr DIRECTORY=dpump_dir1 NETWORK_LINK=source_database_link DUMPFILE=network_export.dmp
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
ASKER CERTIFIED SOLUTION
Avatar of Piloute
Piloute
Flag of France image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Baber Amin

ASKER

Thanks.