-- 대략 아래와 같습니다. create table a_new nologging as select * from a where 1=2 ; insert /*+ PARALLEL(a_new,4) */ into a_new select /*+ PARALLEL(a,4) */ * from a ; create unique index a_new_ux01 on owner.a_new ~~~~~~ nologging parallel 4 ; exec dbms_stats.gather_table_stats(ownname => ’OWNER’, tabname => ’a_new’, estimate_percent=> 10, cascade => TRUE, degree=> 4) ; alter table a_new logging ; alter table a_new noparallel ; alter index a_new_ux01 logging ; alter index a_new_ux01 parallel 1 ;