oracle数据库链
creare database link 数据库链名
connect to 用户名 identified by 密码
using
'
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 要连接的地址(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
数据路径(\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora)
'
select * from 表名@数据库链名;
======================================================================
--数据库链
create database link link_java --定义数据路链
connect to java05 identified by java05
using
'
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.106)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
'
select * from bank@LINK_JAVA;