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