我创建了一个dblink去调用另外一个数据库如下:
create public database link LINKA
connect to aaa identified by aaa123
using '(DESCRIPTION =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 100.223.21.2)
(PORT = 1341)
)
)
(CONNECT_DATA =
(SERVICE_NAME = bbb)
)';
aaa和aaa123是我登陆数据库bbb的用户名和密码
现在的问题是dblink创建好了,在pl/sql的DataLink links下面也可以看到
不过当我调用Select * From aaa.test@LINKA的时候显示错误
ORA-12154 could not resolve the connect identifier specified
这是为什么?
------解决方法--------------------------------------------------------