SQL*Loader-00949: incorrect datafile string specified for
table string subpartition string
- 1 Answers
- 1981 Views
- I also Faced
- E-Mail Answers
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 |
ORA-09214: sfdone: I/O error detected
NNL-00991: Maximum number of reforwards per request: number
TNS-12228: TNS:protocol adapter not loadable
ORA-06042: NETDNT: message receive failure
ORA-12420: required procedures and functions not in policy package "string"
PLS-00419: reference to remote attribute not permitted
ORA-14043: only one partition may be added
PLS-00642: local collection types not allowed in SQL statements
ORA-15049: diskgroup "string" contains string error(s)
ORA-28152: proxy user 'string' may not specify initial role 'string' on behalf of client 'string'
DRG-13306: 'len' attribute value must be in the range string..string, at line string
SQL-02127: Precompiler/SQLLIB version mismatch
Oracle Errors 
