oracle link

create database link 名称

connect to 连接数据库的用户名 identified by 密码

using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 连接数据库得地址)(PORT = 1521))
)
(CONNECT_DATA =
  (SERVICE_NAME =服务名)
)
)';

--从oa测试库连到hr正式库
create database link mthhrsys
connect to hrsys identified by hrsys
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.1.18)(PORT = 1521))
)
(CONNECT_DATA =
  (SERVICE_NAME = mthtest)
)
)';