oracle 大表复制测试

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

Elapsed: 00:00:00.05

SQL> select count(*) from ip_info;

  COUNT(*)
----------
  33992732

Elapsed: 00:00:01.91

SQL> create table ip_info2 as (select * from ip_info);

Table created.

Elapsed: 00:02:21.57

前:

后：