ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Create Database Link

Create Database Link

原创 Linux操作系统 作者:jack198409 时间:2008-01-08 15:11:40 0 删除 编辑

create database link erp.kimo
connect to PG identified by PG123
USING '(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.8.9)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.8.11)(PORT = 1521))

(LOAD_BALANCE = yes)

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = erpora.kimo)

(FAILOVER_MODE =

(TYPE = SELECT)

(METHOD = BASIC)

(RETRIES = 180)

(DELAY = 5)

)

)

)'


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10768286/viewspace-83479/,如需转载,请注明出处,否则将追究法律责任。

上一篇: Call Form 的用法
请登录后发表评论 登录
全部评论

注册时间:2007-12-13

  • 博文量
    135
  • 访问量
    283524