Oracle DBlink的创建

文章由LinuxBoy分享于2019-03-30 04:03:39热评（512）

Oracle DBlink的创建

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

2、创建DBLink

CREATE PUBLIC DATABASE LINK LINK_NAME
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)))';

COMMIT;

-- 数据信息

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

4.删除

drop PUBLIC DATABASE LINK LINK_NAME;

COMMIT;

Oracle DBlink的创建