Oracle中创建数据链

create database link DBLINK_kly
connect to user_name identified By pwd
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.9)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)'

DBLINK_kly  自定义数据链名称

user_name   用户名

pwd  密码  如果密码为数字加双引号（"123456"）

 

 

删除数据链：

DROP DATABASE LINK DBLINK_kly

转载于:https://www.cnblogs.com/huyaguang/p/WelcometoMyQzone.html