Database Links

数据库连接Database Links

创建数据库连接

create database link LOCAL_LINK

  connect to chowmin identified by chowmin

  using '(DESCRIPTION   = (ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT =   1521)))(CONNECT_DATA = (SERVICE_NAME = orcl)))';

查询所有的dblink

select owner,object_name from dba_objects where object_type='DATABASE   LINK';

删除dblink

drop database link LOCAL_LINK;