Oracle Fast Parallel Insert

Use insert append hint for fast inserts. Almost as fast as bulk load.

alter session enable parallel dml;
alter index <INDEX> unusable;
INSERT /*+ append parallel (<ALIAS1>) */
INTO <TABLE1> <ALIAS1>
(
COL1,
COL2
)
SELECT /*+ parallel(ALIAS2) */
COL1,
COL2
FROM
<TABLE2> <ALIAS2>
WHERE
<STUFF>;
commit;
alter index <INDEX> rebuild;