您当前的位置: 主要的导出示例:
1.导出指定表空间:
expdp system/xxx DIRECTORY=dump_dir tableapace=xxx dumpfile=xxx_%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%".dmp logfile=xxx.log
2.导出指定schema:
expdp system/xxx DIRECTORY=dump_dir schemas=xxx dumpfile=xxx_%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%".dmp logfile=xxx.log
3.导出指定的表:
expdp user/xxx DIRECTORY=dump_dir DUMPFILE=dept.dmpTABLES=T1,T2 logfile=xxx.log;
4.并行导出：
expdp system/xxx schemas=xxx DIRECTORY=dump_dir PARALLEL=3 dumpfile=KDJM2008-11-28_%U.dmp logfile=xxx.log
5.导出元数据的选项：
content=metadata_only