DBLINK连接问题
我按如下创建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已经配置好连接了请问那位高手能给出答案,感激不尽!