在
sid:princess
ip: 192.168.0.2
机器B上建立:
create database link mydbl_prince connect to system identified by manager
using 'mydblstr_prince';select a.*,b.* from tablename@mydblstr_prince a ,princess.tablename b不过要在机器b上的tnsnames.ora文件中加入你所建立的mydblstr_princemydblstr_prince=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = prince) --此处为机器a的sid
)
)
sid:princess
ip: 192.168.0.2
机器B上建立:
create database link mydbl_prince connect to system identified by manager
using 'mydblstr_prince';select a.*,b.* from tablename@mydblstr_prince a ,princess.tablename b不过要在机器b上的tnsnames.ora文件中加入你所建立的mydblstr_princemydblstr_prince=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = prince) --此处为机器a的sid
)
)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货