在网上找了许多资料,同时也做了尝试,下面贴出我创建DBLink的SQL语句:create public database link sale_admin connect to informix identified by piccm85
using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 66.1.32.32)(PORT = 19101)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = salesdb) )
)'可是通过测试语句:select * from SALESRENEWAL@sale_admin,得到如下结果:
16:24:47 [SELECT - 0 row(s), 0.000 secs] [Error Code: 12154, SQL State: 66000] ORA-12154: TNS:could not resolve the connect identifier specified
... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec [0 successful, 0 warnings, 1 errors]请有知道的大侠帮帮忙,应该怎么解决这个问题,多谢啦!!!
using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 66.1.32.32)(PORT = 19101)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = salesdb) )
)'可是通过测试语句:select * from SALESRENEWAL@sale_admin,得到如下结果:
16:24:47 [SELECT - 0 row(s), 0.000 secs] [Error Code: 12154, SQL State: 66000] ORA-12154: TNS:could not resolve the connect identifier specified
... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec [0 successful, 0 warnings, 1 errors]请有知道的大侠帮帮忙,应该怎么解决这个问题,多谢啦!!!
connect to his_wh
identified by his
using '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.32.89)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))';select count(1) from if_balancehead@link_his_wh;database link LINK_HIS_WH created.
COUNT(1)
----------------------
264465 我试过了,如果SID用了换行,也是提示成功,但查询就是失败, using的SID不能里的字符串不能断行。