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