Oracle连接远程计算机Oracle数据库的方法
首先配置TNS,方法如下:
TNS连接远程计算机的设置。SYNO为远程计算机的SID
PMSYNO.BJ.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.203)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = SYNO)
)
)
然后建立连接数据库语句:
CREATE DATABASE LINK link_name(任意启名)
CONNECT TO username
IDENTIFIED BY password
USING sql_string;
例如:CREATE DATABASE LINK pm_syno CONNECT TO pmexp IDENTIFED BY pmexp USING syno(前面TNS配好的那个);
使用远程数据库的表时用 :tablename@link_name