oracle-expdp-通过par参数文件导出

expdp通过par参数文件导出

cat exp_mes_new0525.par

userid="/ as sysdba"
DIRECTORY=DATA_PUMP_DIR
dumpfile=expdp_tab_20210525_all_%U.dmp
logfile=expdp_tab_20210525_all.log
tables=userA.tabA
,userA.tabB
,userA.tabC
,userA.tabD
CONTENT=all   
query=
userA.tabC:"where mdate>to_number(to_char(SYSDATE - 90, 'yyyymmdd'))",
userA.tabD:"where mdate >= to_number(to_char(SYSDATE - 90, 'yyyymmdd'))",
COMPRESSION=ALL  
exclude=STATISTICS
PARALLEL=10

导出

nohup expdp parfile=exp_tab_0525.par &