创建dblink
create database link ORACLELINK
connect to SMKMAINV41 IDENTIFIED BY SMKMAINV41
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.18.101)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl101)
)
)';
指定表重新命名一个访问名称,如将SMKP2PMSG表的访问名称命名为odssSMKP2PMSG
这样就可以通过odssSMKP2PMSG访问SMKP2PMSG了
用法是:当两个数据的表明重复时候,可以这样命名
create or replace synonym odssSMKP2PMSG
for SMKP2PMSG@ORACLELINK;
create database link ORACLELINK
connect to SMKMAINV41 IDENTIFIED BY SMKMAINV41
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.18.101)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl101)
)
)';
指定表重新命名一个访问名称,如将SMKP2PMSG表的访问名称命名为odssSMKP2PMSG
这样就可以通过odssSMKP2PMSG访问SMKP2PMSG了
用法是:当两个数据的表明重复时候,可以这样命名
create or replace synonym odssSMKP2PMSG
for SMKP2PMSG@ORACLELINK;