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-19728: data object number conflict between table string and partition string in table string

1 Answers  


ORA-07562: sldext: extension must be 3 characters

1 Answers  


ORA-25425: connection lost during rollback

1 Answers  


ORA-21779: duration not active

1 Answers  


LSX-00262: attribute "~1S" cannot have complex type "~2S"

1 Answers  






ORA-16180: number processes specified for MAX_PARALLEL_SERVERS is too small

1 Answers  


ORA-29824: operator is invalid

1 Answers  


ORA-26678: Streams capture process must be created first

1 Answers   Yahoo,


ORA-12996: cannot drop system-generated virtual column

1 Answers  


NNL-00243: Processing of modification requests is now enabled

1 Answers  


RMAN-03013: Copyright (c) 1995, 2003, Oracle Corporation. All rights reserved.

1 Answers  


ORA-12916: Cannot use default permanent tablespace with this release

1 Answers  


Categories