一个有关oracle中数据链路的问题!!

有两个服务器,名称和IP及tnsnames分别为:
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相连结

有谁能够告诉我!!
[866 byte] By [tengteng_rock-没完没了] at [2008-4-13]
# 1
drop public database link swdl;
create public database link tffserver
CONNECT TO zs IDENTIFIED BY zs
USING 'tffserver';
# 2
好像不行
# 3
我也遇到过相同的问题,不知道为何,最后也没有解决
不过我用别的方法实现了我的要求

copy
xinpingf-白开心 at 2007-10-22 > top of Msdn China Tech,其他数据库开发,SQL Anywhere Studio...
# 4
copy from zs/zs@swdl create table1 using select * from table2;

copy from zs/zs@swdl insert tabel1 using select * from table2;
xinpingf-白开心 at 2007-10-22 > top of Msdn China Tech,其他数据库开发,SQL Anywhere Studio...
# 5
drop public database link swdl;
create public database link tffserver
CONNECT TO zs IDENTIFIED BY zs
USING 'tffserver';

select * from table1@tffserver;

如果还不行,看看你的 全局数据库的名字是否 tffserver,不是则改成你的全局数据库的名字。
goodlucky-沉浮 at 2007-10-22 > top of Msdn China Tech,其他数据库开发,SQL Anywhere Studio...