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-00289: suggestion : string

1 Answers  


LPX-00269: all three access functions (open/close/read) must be provided

1 Answers  


SQL*Loader-00278: Incorrect file specification for parallel load.

1 Answers  


ORA-21600: path expression too long

1 Answers  


IMG-00805: SIGNATURE data has been corrupted or is invalid

1 Answers  






PCC-02011: found identifier greater than 128 characters (truncated)

1 Answers  


ORA-01282: date range specified is invalid

1 Answers  


PLS-00379: CASE statements are not included in this release of PL/SQL

1 Answers  


ORA-39020: invalid mode type string

1 Answers  


NNL-00578: dump_ldap: dump addresses in the domain or region to LDAP

1 Answers  


ORA-01077: background process initialization failure

1 Answers  


ORA-23611: tablespace "string" has more than one data file

1 Answers  


Categories