SQL>create table new_object_directpath as select * from test_dba_objects where 1=2
SQL>alter table new_object_directpath nologging
SQL> SET TIMING ON
Elapsed: 00:00:00.54
(2)修改表的并行模式
SQL> alter table new_object_directpath parallel 8;
(3) insert耗时
SQL> insert /*+parallel (new_object_directpath,8) */ into new_object_directpath select * from test_dba_objects;
1630104 rows created.
Elapsed: 00:00:05.61
未产生数据redo与undo
来源: http://www.cnblogs.com/lovechains/p/7305411.html