Oracle快速创建DBlink的脚本:
-- Create database link
create public database link MSTR
connect to 用户名 identified by 密码
using '(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.100)(PORT = 1521))
(LOAD_BALANCE = yes)
(FAIL_OVER = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = linuxidc.com)
)
)';
说明:将红色部分直接替换即可。