Create Database Link
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 的用法
下一篇：
Oracle 中的Copy命令
请登录后发表评论
登录
全部评论
