Oracle中创建数据链

create database link DBLINK_klyconnect to user_name identified By pwdusing '(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