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