SQL*Loader-00947: subpartition load requested and string has
enabled triggers or constraints
- 1 Answers
- 2332 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-26061: Concurrent direct unloads is not allowed.
ORA-21525: attribute number or (collection element at index) string violated its constraints
ORA-13834: name of SQL profile to be cloned must be provided
ORA-13786: missing SQL text of statement object "string" for tuning task "string"
NNO-00808: Error connecting to region database
TNS-00065: INTCTL: Command cannot be executed remotely
ORA-13155: invalid number of dimensions specified
ORA-31502: invalid number supplied for supplemental_processes
ORA-07279: spcre: semget error, unable to get first semaphore set.
ORA-01351: tablespace given for Logminer dictionary does not exist
ORA-16105: Logical Standby is already running in background
ORA-02366: The following index(es) on table string were processed:
Oracle Errors 
