创建数据链database link and drop (简单实例)

create database link aiki_link
connect to username identified by password
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =ip)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = sid)
(SERVER = DEDICATED)
)

)';

drop database link

DROP DATABASE LINK my_db_link;

DROP PUBLIC DATABASE LINK my_db_link;

----------------------------------------------------------------------------

(1):当database link所要连接的主机将username 更改了密码,只有当database link用户退出或激活现有的会话后才会发现密码更改拒绝提示,不能立即生效,待研究!