SQL*Loader-00947: subpartition load requested and string has
enabled triggers or constraints
- 1 Answers
- 2297 Views
- I also Faced
- E-Mail Answers
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 |
ORA-03280: invalid DATAFILE filename specified
QSM-02174: the materialized view does not have a UNION ALL marker column
LPX-00224: multiple occurrences of attribute "~S" found
DRG-12305: column string data type is not supported for index set columns
QSM-01074: materialized view, string, and query have different no of joins between tables, string
KUP-00562: unknown escape sequence
ORA-14522: Partition-level default tablespace string block size [string] for string string does not match existing string block size [string]
SQL-02146: Attempt to allocate an existing descriptor
ORA-27469: %s is not a valid string attribute
RMAN-06201: Deleted string objects
ORA-23344: constraint (string.string) does not exist
ORA-36668: (XSDPART06) string is not a legal RANGE partition.
Oracle Errors 
