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-24185: Transformation string.string, does not exist

1 Answers  


ORA-28536: error in processing Heterogeneous Services initialization parameters

1 Answers  


ORA-24412: Cannot reinitialize non-existent pool

1 Answers  


ORA-32021: parameter value longer than string characters

1 Answers  


TNS-00229: Error in call: unable to deliver message :string: string string string

1 Answers  


TNS-00095: * to trace_on - argument is considered the trace level

1 Answers  


RMAN-10029: unexpected return code number from PL/SQL execution

1 Answers  


NNO-00850: Error: LDAP query returns string

1 Answers  


ORA-24272: initialization value must be either F or T

1 Answers  


ORA-00362: member is required to form a valid logfile in group string

1 Answers  


ORA-08312: sllfop: unrecognized processing option

1 Answers  


UDI-00016: 'string' parameter requires a value.

1 Answers  


Categories