nologging
- CREATE TABLE T1 NOLOGGING AS SELECT * FROM T2;
- CREATE INDEX T1_IDX ON T1(A) NOLOGGING;
- ALTER INDEX T1_IDX REDUILD ONLINE NOLOGGING;
- ALTER TABLE T1 NOLOGGING;
INSERT /*+ append,parallel(t1) */ INTO T1 SELECT * FROM T2;
/*+ parallel(t 8) */
/*+ index(t t_idx) */