Question: how to copy huge data from one table to another in oracle?
Answer: Use NOLOGGING: This turns off logging, making for a faster copy. ...  Use the parallel clause: Since a table copy does a full table scan of both tables, parallel query will make the copying far faster, (up to cpu_count-1 faster).