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


SQL*Loader-00949: incorrect datafile string specified for
table string subpartition string



SQL*Loader-00949: incorrect datafile string specified for table string subpartition string..

Answer / guest

Cause: The specified datafile is not in the tablespace of
the specified subpartition. Due to use of FILE= keyword on a
subpartitioned table. When loading all subpartitions of a
subpartitioned table, the subpartitions must be in the same
tablespace. When loading a single subpartition, the
tablespace of the subpartition 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-07210: slcpu: getrusage error, unable to get cpu time.

1 Answers  


NNC-00501: warning: "string" parameter value must be between number and number, setting to number

1 Answers  


LSX-00008: feature "~s" is not implemented

1 Answers  


NZE-29031: SSL handshake is required.

1 Answers  


PLS-00604: aggregate function is not allowed here

1 Answers  






ORA-13401: duplicate entry for string in USER_SDO_GEOR_SYSDATA view

1 Answers  


ORA-06134: NETTCP: file access privilege violation

1 Answers  


ORA-04046: results of compilation are too large to support

1 Answers  


ORA-07457: cannot set _INTERNAL_RESOURCE_MANAGER_PLAN because of FORCE

1 Answers  


ORA-36266: (XSCGMDLAGG00) Invalid context for the AGGREGATION function

1 Answers  


ORA-29319: datafile string is not correct

1 Answers  


ORA-19901: database needs more recovery to create new incarnation

1 Answers  






Categories