创建dblink

https://blog.csdn.net/qq_31806719/article/details/83008411

  方法一：

  create database link xxx----即将建立的dblink名
  connect to 数据库用户名 identified by "密码"
  using 'xxx.xxx.xxx.xx-----数据库IP';

create database link TEST_DEV_CENTER
connect to center_test identified by center_test
using '10.6.***.***';

 方法二:

create database link TEST_DEV_CENTER
connect to center_test identified by center_test
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.6.***.***)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test)
)
)';

删除dblink

drop database link TEST_DEV_CENTER;