expdp ‘username/password’ parfile=E:\dmp_tmp\par.txt
DIRECTORY=dmptmp
LOGFILE=SYS_SEND_LOG.log
DUMPFILE=SYS_SEND_LOG.dmp
tables=SYS_SEND_LOG_BAK
query=“where send_dt>=TO_DATE(‘2024-03-13’,‘yyyy-mm-dd’)”
impdp ‘username/password’ directory=dmptmp dumpfile=SYS_SEND_LOG.dmp LOGFILE=SYS_SEND_LOG_imp.log REMAP_TABLESPACE=USERS:AFLOG remap_table=SYS_SEND_LOG_BAK:SYS_SEND_LOG table_exists_action=append
expdp ‘username/password’ parfile=E:\dmp_tmp\par.txt
DIRECTORY=dmptmp
LOGFILE=API_DOCC_LOG.log
DUMPFILE=API_DOCC_LOG.dmp
tables=API_DOCC_LOG_BAK
query=“where STARTTIME>=‘2024-03-13’”
impdp ‘username/password’ directory=dmptmp dumpfile=API_DOCC_LOG.dmp LOGFILE=API_DOCC_LOG_imp.log REMAP_TABLESPACE=USERS:AFLOG remap_table=API_DOCC_LOG_BAK:API_DOCC_LOG table_exists_action=append