目标端创建dblink 登录后复制 create database link test connect to test identified by "test" using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.31.5.111)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = newpaydb) ) )'; select sysdate from dual@test; 1.2.3.4.5.6.7.8.9.10.11.12. 目标端创建导入脚本 这种方式即使源端是DG库,也可以使用数据泵 登录后复制 vim impdp_test.sh impdp \' / as sysdba\' tables=test.tb1,test.tb2 directory=test network_link=test parallel=4 parfile=tbname.par logfile=test.log 1.2. 目标端执行数据导入脚本 登录后复制 nohup ./impdp_test.sh & 1. 原创作者: u_14852239 转载于: https://blog.51cto.com/u_14852239/11729308