SQL*Loader-00943: incorrect datafile string specified for
table string partition string
- 1 Answers
- 2197 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: The specified datafile is not in the tablespace of
the specified partition. Due to use of FILE= keyword on a
partitioned table. When loading all partitions of a
partitioned table, the partitions must be in the same
tablespace. When loading a single partition, the tablespace
of the partition being loaded must be the same as the
tablespace in which the specified datafile file resides.
Action: none
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-01119: error in creating database file 'string'
ORA-29656: Invalid option for USING
DRG-51311: DML lock handle previously allocated
ORA-13148: failed to generate SQL filter
ORA-32132: maximum iterations cannot be changed
ORA-01324: cannot add file string due to DB_ID mismatch
PCC-02312: arrays of VARCHAR greater than 2 dimensions not allowed
ORA-38749: A media recovery has been started.
LFI-00133: Trying to create file string that already exists.
LSX-00295: field element "~S" is not a simple type
ORA-21708: inappropriate operation on a transient object
ORA-36958: (XSFCAST26) The OFFSET value for cycle number cannot be greater than the cycle's PERIODICITY, which is number. You specified number.
Oracle Errors 
