oracle 9i 建立oracle 10g dblink
文章分类:数据库
在oracle9i的机器的tnsnames.ora里配置10g的服务名为:
ora10g =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ip )(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = ora10g)
(SID = ora10g)
)
)
然后:
create database link dblink_test connect to username identified by passwd using 'ora10g ';
create database link DB_TRFF_APP.US.ORACLE.COM
connect to trff_app identified by trff_app using 'ORCL10010g2 ';
create or replace synonym VEHICLE
for TRFF_APP.VEHICLE@DB_TRFF_APP.US.ORACLE.COM;
create or replace synonym VEH_INSURE
for TRFF_APP.VEH_INSURE@DB_TRFF_APP.US.ORACLE.COM;