dblink

查看 创建的dblink

select * from dba_db_links

创建 dblink

create public database link dblinkname connect to username identified by password
　　 using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =ip)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME =servicename)
)
)';

删除dblink

drop public database link dblinkname;