oracle 创建dblink

--创建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;