Oracle 创建dblink

1、检查该用户是否拥有创建dblink权限

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

 

 

 2、用户没有dblink权限，则需要赋权限

grant public database link to username

3、创建dblink，dblink_name可以随便写

CREATE database link dblink_name
 CONNECT TO userName IDENTIFIED BY password
 USING '(DESCRIPTION=
    (ADDRESS_LIST=
         (ADDRESS=(PROTOCOL=TCP)(HOST=ip地址)(PORT=1521))
     )
     (CONNECT_DATA=
         (SERVICE_NAME=数据库实例名)
     )
  )';

4、不需要dblink可以删除

drop public database link dblink_name