一个dblink的问题!
ihlpj 2005-12-14 10:30:39 我想在本地oracle数据库上做一个链接,连接到一个远程数据库。
本地数据库(不在本机上,安装在物理上相近的一台服务器上,应该没关系吧)
JFZWXT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.x.x.xxx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = jfzwxt)
)
)
远程数据库
IBMS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.x.xxx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ibms)
)
)
我建立了一个链接:
create public database link test connect to view identified by view2005 using 'ibms';
提示error:insufficient privileges
(链接ibms数据库的view用户对该库只有查询权限)
这是什么原因啊?请大家指点一下!
谢谢!