1.需要用数据库管理员给otcts用户授予创建dblink的权限
grant create database link to with admin option;
commit;

 

2、创建DBLink

CREATE PUBLIC DATABASE LINK
CONNECT TO IDENTIFIED BY

USING '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = )(PORT = 1521)))(CONNECT_DATA =(SID = )))';

COMMIT;

-- 数据信息

3、用例(调用DBLink的表)：
SELECT * FROM TABLE_NAME@LINK_NAME;

4.删除

drop PUBLIC DATABASE LINK ;

COMMIT;