Oracle Data Pump example
Oracle Data Pump example:
1. Export the specified tablespace:
Expdp system/xxx DIRECTORY = dump_dir tableapace = xxx dumpfile = xxx _ % DATE :~ 0, 4% % DATE :~ 5, 2% % DATE :~ 8, 2% ". dmp logfile = xxx. log
It seems that only tables, indexes, and triggers can be exported, so it is better to use the specified schema.
2. Export the specified schema:
Expdp system/xxx DIRECTORY = dump_dir schemas = xxx dumpfile = xxx _ % DATE :~ 0, 4% % DATE :~ 5, 2% % DATE :~ 8, 2% ". dmp logfile = xxx. log
This method exports all objects in the schema.
3. Export the specified table:
Expdp user/xxx DIRECTORY = dump_dir DUMPFILE = dept. dmpTABLES = T1, T2 logfile = xxx. log;
4. Parallel export:
Expdp system/xxx schemas = xxx DIRECTORY = dump_dir PARALLEL = 3 dumpfile = KDJM2008-11-28 _ % U. dmp logfile = xxx. log
5. Options for exporting metadata:
Content = metadata_only