感谢教会我使用数据库链接的同事,现在将这个分享出来,供大家参考,代码如下:
create database link T21_4
connect to T21_4 identified by 123456
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1.106)(PORT =1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcldev)
)
)';
create database link 数据库链接名称
connect to 调用远程数据库的用户名 identified by 调用远程数据库的密码
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =服务器IP地址)(PORT =端口号))
)
(CONNECT_DATA =
(SERVICE_NAME = 服务名称)
)
)';
一共有6处根据实际情况可改动,我都是用汉字标记的,希望对大家有所帮助。