通过的TabSplit程序的测试, 认为可以将TabSplit和DataCopy的源代码进行整合, 推出Parallel Inside的DataCopy程序, 使之成为Oracle数据库之间数据迁移的利器.

    通过指定并行度(DEGREE)参数即可进行并行数据拷贝.

datacopy user=….. table1=sql_summary table2=sql_summary2 degree=2

    用1000万数据的一个表进行测试, 并行方式执行时屏幕输出如下.

        0 rows processed at 2010-04-16 13:35:55.
        0 rows processed at 2010-04-16 13:35:55.
  1000000 rows processed at 2010-04-16 13:36:04.
  1000000 rows processed at 2010-04-16 13:36:04.
  2000000 rows processed at 2010-04-16 13:36:14.
  2000000 rows processed at 2010-04-16 13:36:14.
  3000000 rows processed at 2010-04-16 13:36:24.
  3000000 rows processed at 2010-04-16 13:36:24.
  4000000 rows processed at 2010-04-16 13:36:34.
  4000000 rows processed at 2010-04-16 13:36:34.
  5000000 rows processed at 2010-04-16 13:36:43.
  5000000 rows processed at 2010-04-16 13:36:43.
  5207041 rows processed at 2010-04-16 13:36:45.
  5378556 rows processed at 2010-04-16 13:36:47.

    由于需要查询一些系统视图来自动对大表进行切分, 需要授于源端用户查询系统视图的权限(SELECT CATALOG ROLE角色)即可, 欢迎下载进行性能测试.