我按如下创建DBLINK(SELECT * FROM table_name@linkfkdemo)SQL可以运行正常
CREATE [PUBLIC] database link linkfkdemo
connect to fkdemo identified by fkdemo
using '(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.213.252.232)(PORT = 1521))
(CONNECT_DATA =
(sid = test)
)
)';但是我按如下方法创建
CREATE DATABASE LINK linkfkdemo
connect to fkdemo
identified by fkdemo using '连接串的名字';再去运行查询语句会返回ORA-12154的错误
我在tnsnames.ora已经配置好连接了请问那位高手能给出答案,感激不尽!
CREATE [PUBLIC] database link linkfkdemo
connect to fkdemo identified by fkdemo
using '(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.213.252.232)(PORT = 1521))
(CONNECT_DATA =
(sid = test)
)
)';但是我按如下方法创建
CREATE DATABASE LINK linkfkdemo
connect to fkdemo
identified by fkdemo using '连接串的名字';再去运行查询语句会返回ORA-12154的错误
我在tnsnames.ora已经配置好连接了请问那位高手能给出答案,感激不尽!
对,先试试tnsname配置对不对。
my_server =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ip)(PORT = 1521))
(CONNECT_DATA =
(SID = test)
)
)DBLINK就是如下写法应该没有问题吧,而且用PL/SQL工具我真接登陆我是可以连到数据库的
CREATE DATABASE LINK linkfkdemo
connect to fkdemo
identified by fkdemo using 'my_server'