一个有关oracle中数据链路的问题!!
tffserver,168.95.0.13
server.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 168.95.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(sid = orcl)
)
)
server,168.95.0.1
tffserver =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 168.95.0.13)(PORT = 1521))
)
(CONNECT_DATA =
(SID = orcl)
)
)
在server上创公用数据链路swdl成功:
drop public database link swdl;
create public database link swdl
CONNECT TO zs IDENTIFIED BY zs
USING 'tffserver';
但在server上通过数据链路swdl访问tffserver上的表table时发生错误
当:select * from table@swdl;
给出:ERROR 位于第 1 行:
ORA-02085: 数据库链接SWDL.US.ORACLE.COM与ORCL.US.ORACLE.COM相连结
有谁能够告诉我!!

