Difference between revisions of "ExpDP / ImpDP"

From Tom's notes
Jump to navigation Jump to search
(Created page with "Commonly used parameters for expdp/impdp: <source lang="sh"> expdp <username> dumpfile=export.dmp logfile=export_exp.log directory=data_pump_dir schemas=user1 flashback_time=s...")
(No difference)

Revision as of 14:14, 31 March 2016

Commonly used parameters for expdp/impdp:

expdp <username> dumpfile=export.dmp logfile=export_exp.log directory=data_pump_dir schemas=user1 flashback_time=systimestamp
impdp <username> dumpfile=export.dmp logfile=export_imp.log directory=data_pump_dir schemas=user1 remap_schema=user1:newuser1