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

NZE-29226: No matching private key found.

1 Answers  


ORA-13411: subset results in null data set

1 Answers  


O2F-00335: Internal error in O2F component of OTT

1 Answers  


ORA-25245: agent name cannot be specified if address is a single-consumer queue or an exception queue

1 Answers  


ORA-25113: GLOBAL may not be used with a bitmap index

1 Answers  






ORA-31086: insufficient privileges to register global schema "string"

1 Answers  


ORA-07480: snchmod: cannot change permissions on ?/dbs/sgalm.dbf.

1 Answers  


ORA-01954: DEFAULT ROLE clause not valid for CREATE USER

1 Answers  


ORA-30508: client logon triggers cannot have BEFORE type

1 Answers  


ORA-29335: tablespace 'string' is not read only

1 Answers  


ORA-38441: System could not derive the list of STORED and INDEXED attributes.

1 Answers  


NZE-28838: no identity descriptor

1 Answers  


Categories