17,377
社区成员
发帖
与我相关
我的任务
分享
drop database link b_link;
create database link b_link
connect to <b机数据库登录名称> identified by "<b机数据库登录密码>"
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <b机IP>)(PORT = 1521))
(LOAD_BALANCE = yes)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = <b机数据库SID>)
)
)';
/
然后调用表时,如果想引用B机student表,写成这样
select * from student@b_link
注意,以上都是在pl/sql的sql窗口执行
--创建 新a2 链接
drop database link <链路名>;
create database link <链路名>
connect to <登陆账户> identified by "landmark"
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <目标主机IP>)(PORT = 1521))
(LOAD_BALANCE = yes)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = <sid名>)
)
)';
/