oracle 11g怎样配置才能连接远程数据库

2024-11-20 14:48:13
推荐回答(1个)
回答1:

创建数据库链:
create database link dblk_to_cdm
connect to identified by
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
)
(CONNECT_DATA =
(SID = <数据库的SID>)
)
)';