Oracle快速创建DBlink的脚本

Oracle快速创建DBlink的脚本

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 = bkjia.com)
    )
)';

说明：将红色部分直接替换即可。