Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-30514: system trigger cannot modify tablespace being made read only

1 Answers  


ORA-32636: Too many rules in MODEL

1 Answers  


ORA-19560: %s is not a valid device limit

1 Answers  


PCC-02361: Use of ARRAYLEN with SQL bind arrays is ignored

1 Answers  


TNS-00226: Unable to contact pump number to send broadcast message string

1 Answers  






ORA-13389: unable to compute buffers or intersections in analysis function

1 Answers  


ORA-29384: number of children for plan string exceeds string

1 Answers  


ORA-06126: NETTCP: ORASRV unable to open network connection

1 Answers  


ORA-31196: XML nodes over string in size cannot be printed

1 Answers  


ORA-06032: NETDNT: connect failed, access control data rejected

1 Answers  


PCB-00319: EXEC ORACLE statements are an Oracle extension

1 Answers  


ORA-21613: key does not exist

1 Answers  






Categories