--创建dblink
create public database link a --dblink连接名
connect to user identified by password--用户名和密码
using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 数据库IP地址)(PORT = 1521)))
(CONNECT_DATA =(SERVICE_NAME = orcl)))';
--测试dblink
select * from MPI_CONF_FIELD@a
--删除dblink
drop public database link a;
-- 查询现有的dblink
select * from dba_db_links;
create public database link a --dblink连接名
connect to user identified by password--用户名和密码
using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 数据库IP地址)(PORT = 1521)))
(CONNECT_DATA =(SERVICE_NAME = orcl)))';
--测试dblink
select * from MPI_CONF_FIELD@a
--删除dblink
drop public database link a;
-- 查询现有的dblink
select * from dba_db_links;