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