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;