Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

AMD-00148: Workspace "string" is not currently open. No update done.

1 Answers  


ORA-31445: invalid lock handle while acquiring lock on string

1 Answers  


RMAN-00601: fatal error in recovery manager

1 Answers  


ORA-09979: skxfqhsnd: Error Sending a message to another endpoint

1 Answers  


ORA-30351: query rewrite does not currently support this expression

1 Answers  






LRM-00112: multiple values not allowed for parameter 'string'

1 Answers  


NNL-00235: Auto-refresh failure-retry expiration period is now string

1 Answers  


ORA-07207: sigpidu: process ID string overflows internal buffer.

1 Answers  


ORA-13284: failure to copy geometry object for conversion in place

1 Answers  


QSM-02067: no partition key or PMARKER or join dependent expression in select list

1 Answers  


ORA-22053: overflow error

1 Answers  


ORA-16167: LGWR network server could not switch to non-blocking mode

1 Answers  






Categories