oracle 跨表间与用户的备份与恢复

expdp beiyunhe/beiyunhe@192.168.1.60/beiyunhe directory=dump_dir1 dumpfile=a1.dmp CONTENT=METADATA_ONLY Tables=SR_RCPBTI_B,SR_RCPLET_C,SR_RCISET_C,SR_RCFET_C,LV_LGIT_B,LV_LHET_B,LV_LTSET_C,LV_LHLT_F,LV_LHPLS_F,RV_RVGIT_B,RV_RVBTI_B,RV_RMPPOIRT_F,RV_RFORF_F,RV_RTEBTI_F,RV_SSMRT_F,RV_RRLS_F,SU_SGIT_B,SU_SDPT_B

impdp ydh/ydh@192.168.1.60/ydhdb directory=dump_dir dumpfile=a1.dmp remap_schema=beiyunhe:ydh

 

expdp beiyunhe/beiyunhe@192.168.1.60/beiyunhe directory=dump_dir1 dumpfile=a2.dmp CONTENT=METADATA_ONLY Tables=SU_SPET_C,SU_GHGET_C,SU_SWLPDRT_C,SU_RDPET_C,SU_SSQLS_F,SU_SHRLS_F,SU_SHPLS_F

 

impdp ydh/ydh@192.168.1.60/ydhdb directory=dump_dir dumpfile=a2.dmp remap_schema=beiyunhe:ydh

 

 

expdp beiyunhe/beiyunhe@192.168.1.60/beiyunhe directory=dump_dir1 dumpfile=a3.dmp CONTENT=METADATA_ONLY Tables=TCZUS,WPCD,DCCFJD,SSWFAJLACP,XWBL,XCKYBL,AJCLCPB,AJYJ,AJYJHU,XZCFGZS,TZGZS,SDHZ,AJJTTL,CFJDS,ZWCLSP,WPCLTZ,SXZCFAJJABG

impdp ydh/ydh@192.168.1.60/ydhdb directory=dump_dir dumpfile=a3.dmp remap_schema=beiyunhe:ydh

 

expdp beiyunhe/beiyunhe@192.168.1.60/beiyunhe directory=dump_dir1 dumpfile=a4.dmp CONTENT=METADATA_ONLY Tables=LM_BUG
impdp ydh/ydh@192.168.1.60/ydhdb directory=dump_dir dumpfile=a4.dmp remap_schema=beiyunhe:ydh


expdp ydh/ydh@192.168.1.60/ydhdb directory=dump_dir dumpfile=a5.dmp REMAP_TABLESPACE=USERS:YDH

impdp ydh/ydh@192.168.1.60/ydhdb directory=dump_dir dumpfile=a5.dmp  TABLE_EXISTS_ACTION=replace REMAP_TABLESPACE=USERS:YDH

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值