Oracle创建DB LINK

查询创建DB LINLK权限

select * from user_sys_privs where privilege like upper('%DATABASE LINK%'); 

 

创建

create public database link 连接名    
 connect to 登录用户 identified by 登录密码
 using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 地址)(PORT = 端口)))(CONNECT_DATA =(SERVICE_NAME = 服务名)))';

 

验证

select * from 表名@连接名;