笔记：使用parfile进行的数据导入导出

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