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-22286: insufficient privileges on file or directory to perform string operation

1 Answers  


ORA-14189: this physical attribute may not be specified for an index subpartition

1 Answers  


ORA-31629: unable to allocate additional memory

1 Answers  


RMAN-06290: Report of database schema

1 Answers  


ORA-12202: TNS:internal navigation error

1 Answers  






RMAN-06474: maintenance channels are not allocated

1 Answers  


ORA-08340: This command not allowed on nCUBE, only one thread is ever used.

1 Answers  


ORA-09859: sfngat: the input file name is not in the autobackup OMF format

1 Answers  


SQL-02102: Inconsistent cursor cache. No global cursor entry.

1 Answers  


LFI-00004: Call to string failed.

1 Answers  


ORA-19651: cannot apply offline-range record to datafile string: SCN mismatch

1 Answers  


ORA-36400: (XSSPROP02) workspace object is not a valid variable name.

1 Answers  


Categories