从远端数据库复制到本地数据库

参考：http://hi.baidu.com/fuzylogic/blog/item/4e2532433a495f169313c685.html

http://www.join2us.com/dv_rss.asp?s=xhtml&boardid=16&id=18&page=1

 

一、创建dblink两种方法：(pl/sql的Sql Window和Command Window运行命令两者结果一样)

1. SQL窗口语句：

create database link dblink_name connect to user_name identified by password using ‘database_name’;

举例：

create database link linksherry connect to system identified by system using ‘bjlx’;

配置tnsnames.ora如下：

bjlx =                                                             

  (DESCRIPTION =                                                     

    (ADDRESS_LIST =