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.
insert /*+ parallel (100) */ ...
?