导出:
expdp goldengate/goldengate DIRECTORY=DUMP_FILE_DIR CONTENT=METADATA_ONLY DUMPFILE=EPI_XG_INFO.dmp tables=EPI_HUNAN.EPI_XG_INFO logfile=EPI_XG_INFO.log
expdp goldengate/goldengate DIRECTORY=DUMP_FILE_DIR CONTENT=METADATA_ONLY DUMPFILE=EPI_XG_JZJL.dmp tables=EPI_HUNAN.EPI_XG_JZJL logfile=EPI_XG_JZJL.log
expdp goldengate/goldengate DIRECTORY=DUMP_FILE_DIR CONTENT=METADATA_ONLY DUMPFILE=EPI_JZJL.dmp tables=EPI_HUNAN.EPI_JZJL logfile=EPI_JZJL.log
expdp goldengate/goldengate DIRECTORY=DUMP_FILE_DIR CONTENT=METADATA_ONLY DUMPFILE=EPI_CHILDINFO.dmp tables=EPI_HUNAN.EPI_CHILDINFO logfile=EPI_CHILDINFO.log
导入:
impdp system/oracle DIRECTORY=DATA_PUMP_DIR DUMPFILE=EPI_XG_INFO.dmp tables=epi_hunan.EPI_XG_INFO remap_tablespace=EPI_HUNAN:TPS_DATA
impdp system/oracle DIRECTORY=DATA_PUMP_DIR DUMPFILE=EPI_XG_JZJL.dmp tables=epi_hunan.EPI_XG_JZJL remap_tablespace=EPI_HUNAN:TPS_DATA
impdp system/oracle DIRECTORY=DATA_PUMP_DIR DUMPFILE=EPI_JZJL.dmp tables=epi_hunan.EPI_JZJL remap_tablespace=EPI_HUNAN:TPS_DATA,NJZ01:TPS_DATA,NJZ03:TPS_DATA,NJZ02:TPS_DATA,NJZ04:TPS_DATA,NJZ05:TPS_DATA,NJZ06:TPS_DATA,NJZ07:TPS_DATA,NJZ08:TPS_DATA,NJZ09:TPS_DATA,NJZ10:TPS_DATA,NJZ11:TPS_DATA,NJZ12:TPS_DATA,NJZ13:TPS_DATA,NJZ14:TPS_DATA,NJZ15:TPS_DATA,INDEX_REPORT:TPS_DATA EXCLUDE=STATISTICS REMAP_SCHEMA=epi_hunan:hxl
impdp system/oracle DIRECTORY=DATA_PUMP_DIR DUMPFILE=EPI_CHILDINFO.dmp tables=epi_hunan.EPI_CHILDINFO remap_tablespace=EPI_HUNAN:TPS_DATA,NCHILD08:TPS_DATA,NCHILD09:TPS_DATA,NCHILD01:TPS_DATA,NCHILD03:TPS_DATA,NCHILD02:TPS_DATA,NCHILD04:TPS_DATA,NCHILD05:TPS_DATA,NCHILD06:TPS_DATA,NCHILD07:TPS_DATA,NCHILD12:TPS_DATA,NCHILD10:TPS_DATA,NCHILD11:TPS_DATA,NCHILD13:TPS_DATA,NCHILD14:TPS_DATA,NCHILD15:TPS_DATA REMAP_SCHEMA=epi_hunan:hxl EXCLUDE=STATISTICS
原文:https://www.cnblogs.com/hxlasky/p/14738618.html