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

SQL*Loader-00472: collections can contain only one non FILLER field specification

1 Answers  


ORA-01044: size string of buffer bound to variable exceeds maximum string

1 Answers  


NNL-00570: save_config [<server_list>] : saves server configuration to parameter file

1 Answers  


ORA-39141: dump file "string" is a duplicate of dump file "string"

1 Answers  


ORA-25353: branch marked for deletion

1 Answers  






DRG-11726: phrase is not a preferred term

1 Answers  


LSX-00232: invalid unsigned long "~S"

1 Answers  


DRG-52112: improper Chinese string string of length number

1 Answers  


ORA-01182: cannot create database file string - file is in use or recovery

1 Answers  


SQL*Loader-00800: %s specified and ignored

1 Answers  


ORA-08414: error encountered in string

1 Answers  


TNS-00072: * start - start up process_name

1 Answers  


Categories