oracle单表按时间导出

[oracle@server1 ~]$ cat tmp.par 

dumpfile=tmp_200703.dmp

directory=dmpdir

TABLES=tmp

query="WHERE to_char(create_time,'yyyy-mm-dd') > '2017-01-01' and to_char(create_time,'yyyy-mm-dd') < '2019-12-31'"

[oracle@server1 ~]$expdp hr/hr parfile=tmp.par

或者 include 加转译符

expdp hr/hr  dumpfile=yw.dmp directory=pump_dir  logfile=yw.log  compression=all content=data_only include=TABLE:\" IN \(SELECT TABLE_NAME FROM HR.YW_TABLE \)\"