1,动态DB LINK
create public database link hhh
connect to sxdd[连接数据库的用户名] identified by sxdd[对应密码]
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = tcp)(HOST = 192.168.1.101[数据库ip地址])(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl[实例名])
)
)';
connect to sxdd[连接数据库的用户名] identified by sxdd[对应密码]
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = tcp)(HOST = 192.168.1.101[数据库ip地址])(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl[实例名])
)
)';
2,利用tns
先用Oracle的Net Manager工具新建一个服务(TNS)例如"test1"[注意这个是在本地的数据库里面建立,就是说在本地数据库中使用的tns服务。]
如图所示: