The table below has 1,346,163 records.
The time it takes to create another table with normal CTAS is 41 seconds.
If we use CTAS with PARALLEL NOLOGGING the time it takes is reduce to 22 seconds.
Remember the keyword PARALLEL denotes the number of parallel threads that needs to run to do the job quickly. Ideally you should keep the parallel count between 3 to 5.
The keyword NOLOGGING tells Oracle not to enter anything in the redo log files. Ideally, when any SQL command is executed, Oracle keeps on writing the events in the redo log file so that if anything goes wrong, Oracle can rollback the changes.
Hence adding the NOLOGGING parameter will ensure that you save on the time that oracle spends to log events.
Try it out with this syntax and you will see a marked improvement.