如何访问另一个oracle数据库
发布网友
发布时间:2022-04-23 04:08
我来回答
共2个回答
热心网友
时间:2022-04-08 07:05
用database link
1、配置$ORACLE_HOME/networks/admin/tnsnames.ora
添加
orclsvr2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.10.1.2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
2、create public database link srv2_link connect to username identified by password using 'orclsvr2';
3、这样使用select count(*) from tab@srv2_link;
热心网友
时间:2022-04-08 08:23
你猜.