Oracle新建DBLINK

发布时间 2023-09-15 16:00:46作者: 不爱上班的阿鹏

如果没有创建DBLINK的权限,先授个权:

grant CREATE PUBLIC DATABASE LINK,DROP PUBLIC DATABASE LINK to 用户;

然后在当前用户下建立DBLINK:

create public database link  DBLINK名字
connect to 用户名  identified by  "密码"
using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 110.110.110.110)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = orcl)))';

建好了之后搜索一下当前的所有DBLINK(看看有木有):

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

select * from dba_db_links;

如果要修改DBLINK地址(啊~直接删掉~):

drop public database link DBLINK名字