在dba日常运维过程经常会用到导出某个schema并排除部分表，或者是某个表里的部分数据这种需求。
1.导出schema排除特定表（通过sys导出）特殊字符需要转义，否则会报错
expdp \'sys/"Sys_zjgat$1234" as sysdba\' directory=xtts dumpfile=xtts_U%.dmp logfile=xtts.log schemas=xcky exclude=statistics,index,trigger,table:\"in \(\'common_picture\'\)\" parallel=8
2.导出表中部分数据
expdp \'sys/"Sys_zjgat$1234" as sysdba\' directory=xtts dumpfile=xtts_U%.dmp logfile=xtts.log tables=common_picture exclude=statistics,index,trigger query=common_picture:\"where create_datetime\>=\to_date\(\'20120101\',\'yyyy-mm-dd\'\)\" content=data_only parallel=8
标签：picture,expdp,导出,sys,xtts,query From： https://www.cnblogs.com/Roobbin/p/16724982.html