dblink创建之oracle
1.查看用户是否有建立db_link的权限
select * from user_sys_privs where privilege like upper('%DATABASE LINK%') AND USERNAME='WANGYONG';
grant create public database link to wangyong;
2.创建db_link
create public database link YDFB connect to fhs identified by fhs using '(DESCRIPTION =
(ADDRESS_LIST = (
ADDRESS = (PROTOCOL = TCP)(HOST = 20.2.3.36)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = yddb)
)
)';