How to run INSERT INTO AS SELECT in parallel on Oracle?

by korodani   Last Updated September 11, 2019 10:06 AM

I have a very large table AUD$ that I want to copy it to another empty one with the same structure AUD_BACKUP.

INSERT INTO TEST_USER.AUD_BACKUP 
    SELECT * FROM SYS.AUD$;
COMMIT;

How do I use parallel for INSERT as well as for SELECT ? I can afford to run in 100 parallels. I am on Oracle db 12.2.



Related Questions


Bloom Filter about filtering in oracle

Updated December 31, 2016 08:02 AM

Oracle data pump import parallel configuration

Updated August 10, 2017 18:06 PM

How to handle 10k parallel queries on an Oracle 12?

Updated December 13, 2017 15:06 PM

IMPDP Parallel insert operation

Updated May 02, 2018 19:06 PM