Oracle 中创建dblink

 1 --创建dblink
 2  create public  database link XXXX  --dblink连接名
 3 　　connect to 用户名 identified by 密码 --用户名和密码
 4 　　using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 172.16.12.185)(PORT = 1521)))
 5 (CONNECT_DATA =(SERVICE_NAME = HIPPDB)))';
 6 
 7 --测试dblink
 8 select * from MPI_CONF_FIELD@dblink连接名
 9 --删除dblink
10 drop public  database link XXX
11 --  查询现有的dblink
12 select * from dba_db_links;

 

转载于:https://www.cnblogs.com/jijinming/p/9458160.html