ExpDP / ImpDP

From Tom's notes
Revision as of 13:14, 31 March 2016 by Tom (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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
Retrieved from "https://www.hacks.be/wiki/index.php?title=ExpDP_/_ImpDP&oldid=20"