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 \)\"