Oracle的DBLINK是一种高效的系统集成方式,很便捷的打通多套应用系统的数据库打通。下面介绍一下查询,创建,删除DBLINK的方法。
1,查询DBLINK
select * from dba_db_links;
2,创建DBLINK
create database link todm
connect to DM identified by DM
using ' (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.19.4.122)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)';
3,删除DBLINK
DROP PUBLIC DATABASE LINK TODM;