我现在的机器装的是ORACLE的客户端,应该如何连接两个数据库drop public database link bbb;create public database link bbb CONNECT TO attemper IDENTIFIED BY attemper USING 'xkmes.xkcdomin'; SQL> select * from dual@bbb; select * from dual@bbb * ERROR 位于第1行: ORA-12154: TNS:无法处理服务名
创建数据库链接语句有问题,应该是: create public database link bbb CONNECT TO attemper IDENTIFIED BY attemper USING 'xkmes';
CONNECT TO attemper IDENTIFIED BY attemper
USING 'xkmes.xkcdomin';
SQL> select * from dual@bbb;
select * from dual@bbb
*
ERROR 位于第1行:
ORA-12154: TNS:无法处理服务名
create public database link bbb
CONNECT TO attemper IDENTIFIED BY attemper
USING 'xkmes';