HomeOracleOracle Error SQL*Loader-00937: parallel load requested and string has enabled triggers or constraints

Oracle Error SQL*Loader-00937: parallel load requested and string has enabled triggers or constraints

Oracle Error Message

SQL*Loader-00937: parallel load requested and string has enabled triggers or constraints

Reason for the Error

A request was made for a parallel direct load, but the object to be loaded has an enabled constraint (check, referential) and/or enabled triggers.

Solution

Disable the offending enabled constraints and/or triggers and retry the parallel direct load.

Share:

Leave a Reply

You May Also Like

Oracle Error Message CLSGN-32767: Internal error. Reason for the Error An unexpected error occurred. Solution Examine the message(s) that accompany...
Oracle Error Message CLSGN-00211: OCR batch operation failed. string Reason for the Error Setting a set of Oracle Cluster Registry...
Oracle Error Message CLSGN-00210: failed to get value for OCR key “string”. string Reason for the Error It was not...