oracle建db_link方法

首先配置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