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

DRG-50607: failed to obtain column info for cid string

1 Answers  


ORA-25229: error on transformation of message string string

1 Answers  


RMAN-08101: channel string: proxy validation complete

1 Answers  


ORA-30116: syntax error at 'string' following 'string'

1 Answers  


ORA-25211: invalid DELAY specified when using sequence deviation

1 Answers  


ORA-23426: deferred RPC queue has entries for string

1 Answers  


ORA-16179: incremental changes to "string" not allowed with SPFILE

1 Answers  


PCC-00042: Must EXEC SQL INCLUDE SQLCA when mode=ANSI and WHENEVER SQLWARNING used

1 Answers  


LFI-00147: File string.string does not exist

1 Answers  


TNS-00025: INTCTL: The ORACLE environment is not set up correctly

1 Answers  


ORA-29884: domain index is defined on the column to be dropped

1 Answers  


ORA-07580: spstp: $GETJPIW failure

1 Answers  


Categories