SQL*Loader-00947: subpartition load requested and string has enabled triggers or constraints

SQL*Loader-00947: subpartition load requested and string has enabled triggers or constraints

Cause: A request was made for a direct load of a single subpartition, but the object to be loaded has an enabled constraint (check, referential) and or or enabled triggers.

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

No comments:

Post a Comment