--需要有对D6PRI的映射关系
create public database link d6 connect to zdadmin identified by password1 using 'd6pri';
-- 直接配置
-- 如果创建全局 dblink,必须使用 systm 或 sys 用户,在 database 前加 public。
create public database link d6
connect to zdadmin identified by password1
using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 192.168.0.161)(PORT = 3725)))(CONNECT_DATA =(SERVICE_NAME = d6)))';
create public database link d6 connect to zdadmin identified by password1 using 'd6pri';
-- 直接配置
-- 如果创建全局 dblink,必须使用 systm 或 sys 用户,在 database 前加 public。
create public database link d6
connect to zdadmin identified by password1
using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 192.168.0.161)(PORT = 3725)))(CONNECT_DATA =(SERVICE_NAME = d6)))';