1.需要用数据库管理员给otcts用户授予创建dblink的权限
grant create database link to user_name with admin option;
commit;
CONNECT TO LINK_DB_USER IDENTIFIED BY LINK_DB_PASSWORD
USING '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 10.23.118.124)(PORT = 1521)))(CONNECT_DATA =(SID = DB_NAME)))';
SELECT * FROM TABLE_NAME@LINK_NAME;
4.删除
grant create database link to user_name with admin option;
commit;
2、创建DBLink
CREATE PUBLIC DATABASE LINK LINK_NAMECONNECT TO LINK_DB_USER IDENTIFIED BY LINK_DB_PASSWORD
USING '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 10.23.118.124)(PORT = 1521)))(CONNECT_DATA =(SID = DB_NAME)))';
COMMIT;
-- 数据信息
3、用例(调用DBLink的表):SELECT * FROM TABLE_NAME@LINK_NAME;
4.删除
drop PUBLIC DATABASE LINK LINK_NAME;
COMMIT;