oracle创建DBLINK

--1.创建DBLINK

 

create public database link OMS@link1
  connect to ESP identified by *****

  using '(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (FAIL_OVER = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = OMS)
    )
)';

--2.通过DBLINK访问数据库。

 

select * from dual@OMS@link1;