SQL*Loader-00943: incorrect datafile string specified for
table string partition string



SQL*Loader-00943: incorrect datafile string specified for table string partition string..

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

Post New Answer

More Oracle Errors Interview Questions

ORA-07238: slemcl: close error.

1 Answers  


ORA-24025: invalid value string, QUEUE_PAYLOAD_TYPE should be RAW or an object type

1 Answers  


NNL-00558: set|show namesctl_trace_level : set|show the controller's tracing level

1 Answers  


RMAN-06546: Error occurred getting response - assuming NO response

1 Answers  


ORA-02089: COMMIT is not allowed in a subordinate session

1 Answers   Oracle,






NNL-00282: Cancelled restart

1 Answers  


NNL-00579: _scan: find objects/records matching the given types

1 Answers  


ORA-15057: specified size of string MB is larger than actual size of string MB

1 Answers  


PLS-00201: identifier 'string' must be declared

1 Answers  


SQL*Loader-00280: table string is a temporary table

1 Answers  


LRM-00106: out of memory

1 Answers  


ORA-28001: the password has expired

1 Answers  


Categories