--查询创建权限
SELECT * FROM USER_SYS_PRIVS DD WHERE DD.privilege LIKE '%DATABASE LINK%' AND USERNAME='A';
--如果没有权限进行授权
GRANT CREATE PUBLIC DATABASE LINK TO A;
--创建DBLINK
CREATE PUBLIC DATABASE LINK A_TO_B CONNECT TO B_USER IDENTIFIED BY B_PSW USING
'(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 88.88.88.88)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = B_SID)
)
)';
--测试连接
SELECT SYSDATE FROM dual@A_TO_B_CONNECT;
注意点:
1.A用户必须具备创建DBLINK权限;
2.USING如果密码已数字开头需要双引号;
3.USING后跟本地客户端配好连接串,如果报错ORA-12145使用上述办法进行测试。