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.