-- Drop existing database link
drop public database link DBLINK_NAME;
-- Create database link
create public database link DBLINK_NAME
connect to TL_LINK_DB
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP地址)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = >DB服务名)
)
)';
说明:
①.删除已经存在的database link;
②.创建database link:
TL_LINK_DB—>远程数据库名
IP地址 —>远程数据库IP地址
1521 —>连接的端口
DB服务名 —>远程数据库服务名