--oracle中有时在库间迁移时,按schema导出时不会导出public对象,可以通过数据泵expdp和impdp的方式进行迁移
--测试如下:
环境:11gr2 redhat7 单节点
步骤:
1、创建public dblink
create public database link test
connect to r_test IDENTIFIED BY test123
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.3)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = mydb11g)
)
)';
测试dblink连通性
select * from dual@test;
--DUMMY
--X
2、创建导出目录
CREATE DIRECTORY test AS '/oracle/dump_dir';
3、按dblink名称导出dblink,注意命令行的字符转义,如果不想用转义可以通过parfile方式导
expdp r_test/test123 DIRECTORY=test dumpfile=expdp_public_dblink.dmp LOGFILE=expdp_public_dblink.log full=y include=DB_LINK:\"IN \(\'TEST\'\)\"
Connecte