How to run INSERT INTO AS SELECT in parallel on Oracle? 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.
You should use direct path INSERT.
For select you can use PARALLEL hint in the same statement.  you may use PARALLEL without any parameter or use PARALLEL(n) with n number of thread.
Let me know if you need more explanation on this.