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-01943: IDENTIFIED BY already specified

1 Answers  


ORA-30039: Cannot drop the undo tablespace

1 Answers  


SQL*Loader-00504: Error skipping records in file (string)

1 Answers  


ORA-08264: ora_addr: cannot close nameserver

1 Answers  


TNS-12161: TNS:internal error: partial data received

1 Answers  






ORA-00407: rolling upgrade from release string.string to string.string is not allowed

1 Answers  


ORA-12341: maximum number of open mounts exceeded

1 Answers  


ORA-08441: closed parenthesis missing in picture mask

1 Answers  


ORA-16560: unable to convert document, syntax error at "string"

1 Answers  


RMAN-06451: proxy copy handle=string recid=string stamp=string

1 Answers  


ORA-29278: SMTP transient error: string

1 Answers  


NNL-00876: Total update processing time: string

1 Answers  


Categories