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..

Answer / guest

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 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-36628: (XSAGMODLIST03) MODEL workspace object could not be added to AGGMAP workspace object.

1 Answers  


NNO-00270: ORACLE error string

1 Answers  


ORA-06314: IPA: Event set up failure

1 Answers  


DRG-10581: indirect datastores cannot be used with long or lob text columns

1 Answers  


SQL*Loader-00514: Error getting elapsed time

1 Answers  






ORA-38482: no elementary attributes defined in the attribute set

1 Answers  


ORA-23315: repcatlog version or request string is not supported by version string

1 Answers  


SQL*Loader-00561: end of file

1 Answers  


ORA-28667: USING INDEX option not allowed for the primary key of an IOT

1 Answers  


LSX-00106: duplicate attribute "~S"

1 Answers  


ORA-01286: start interval required

1 Answers  


CLSS-00200: local node string not listed in configuration

1 Answers  


Categories