1、查看数据库中存在的DBlink 防止出现冗余的链接。使用sql:select t.* from dba_objects t where object_type='DATABASE LINK';或者select * from dba_db_links;
2、创建dblink的用户有对应的数据库权create public database link 或者create database link 如果没有，需要具有dba权限的用户授权此用户创建dblink的权限；可以使用sql:grant create public database link,create database link to scott;
3、创建dblink 创建dblink；实例：create public database link pms_dblink connect to PMS identified by pms01 using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST =xx.xx.xx.xx)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME =serviceName)))';
4、查看dblink是否创建成功select t.* from dba_objects t where object_type='DATABASE LINK';
5、通过查询数据判断是否可以正常链接使用格式为 select * from table_name@dblink_name;实例select * from table_name@pms_dblink;
6、删除dblink；drop public datebase link dblink_name
