脚本之不同数据库间不同表列的数据复制

create database link XXX_LINK
  connect to name identified by pwd    using '
      (DESCRIPTION =
          (ADDRESS_LIST =
              (ADDRESS =
                 (PROTOCOL = TCP)
                 (HOST = XXX.XXX.XXX)
                 (PORT = 1521)) )
              (CONNECT_DATA =
                  (SERVICE_NAME = XXXX)

         ) )';

提示ora-12169，故而将(DESCRIPTION =
          (ADDRESS_LIST =
              (ADDRESS =
                 (PROTOCOL = TCP)
                 (HOST = XXX.XXX.XXX)
                 (PORT = 1521)) )
              (CONNECT_DATA =
                  (SERVICE_NAME = XXXX)
         ) )放在tnsname.ora中。

Insert into Table2(field1,field2,...) select value1,value2,... from Table1@XXX_LINK

参考：创建dblink  谷歌

http://liumanyun.blog.hexun.com/5963987_d.html