1.创建DBlink（把13上的ORCL表空间导到12上IASDB上---zgrmdx表空间）

create public database link connect to <被连接库的用户名> identified by <被连接库的密码> using '';

举例：
create public database link
dsztlink connect to
dszt identified by
password using 'DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.12)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = iasdb)
    )';

创建DBlink语句：
create public database link ZGRMDX connect to zgrmdx identified by password using '(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.13)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORCL)
    )
  )'; 
2.创建后单击右键"ZGRMDX.US.ORCLE.COM"选“Test”

3.出现如下图所示：

4.你可以执行以上sql语句看是否连接，测试成功后，如下图效果：

5.然后执行

以下sql语句：
select 'insert into '||t.table_name ||' select * from ' || t.table_name ||'@ZGRMDX;' from user_tables@ZGRMDX t

6.就是把搜出来insert的语句执行一下，就OK啦