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)
)
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用户退出或激活现有的会话后才会发现密码更改拒绝提示,不能立即生效,待研究!