首页 > 其他 > 详细

expdp/impdp

时间:2021-05-07 14:52:25      阅读:28      评论:0      收藏:0      [点我收藏+]

导出:
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

expdp/impdp

原文:https://www.cnblogs.com/hxlasky/p/14738618.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!