SQL*Loader-00943: incorrect datafile string specified for
table string partition string
- 1 Answers
- 2340 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-14606: Tablespace was specified for previous subpartitions in template but is not specified for string
ORA-08314: sllfcf: Error closing file
ORA-15035: no disks belong to diskgroup "string"
ORA-29837: insufficient privileges to execute implementation type
PLS-00239: invalid external type specification for SQLCODE
PLS-00414: no column 'string' in table
NNL-00252: DEFAULT-FORWARDER-ONLY mode is now disabled
ORA-30074: GLOBAL partitioned index on TIME/TIMESTAMP WITH TIME ZONE not allowed
ORA-36154: (XSMXAGGR01) workspace object is not a data variable.
ORA-01865: not a valid era
ORA-12615: TNS:preempt error
ORA-22160: element at index [string] does not exist
Oracle Errors 
