0

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.

0

You should use direct path INSERT. You can get a more detail insight on direct path INSERT from http://www.thisissanjeeva.com.

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.