SQL*Loader-00938: partition load requested and string has
enabled triggers or constraints



SQL*Loader-00938: partition load requested and string has enabled triggers or constraints..

Answer / guest

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

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-23426: deferred RPC queue has entries for string

1 Answers  


ORA-29358: resource plan string does not exist

1 Answers  


LPX-00659: Output write failed.

1 Answers  


ORA-30725: JDWP-based debugging is not yet available

1 Answers  


ORA-28278: No domain policy registered for password based GLOBAL users.

1 Answers  






LPX-00123: duplicate ID "~S"

1 Answers  


ORA-22930: directory does not exist

1 Answers  


LSX-00124: "list" element is improperly defined

1 Answers  


TNS-00536: Connection entered inappropriate state

1 Answers  


PLS-00375: illegal GOTO statement; this GOTO cannot branch to label 'string'

1 Answers  


ORA-14612: Duplicate lob segment name string for lob column string in template

1 Answers  


ORA-14628: specification of bounds is inconsistent with LIST method

1 Answers  


Categories