SQL*Loader-00402: Unable to determine length of column
string from specification
- 1 Answers
- 2361 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: The specified datatype does not have an implied
length (for example, a numeric external or RAW datatype), it
is not specified with delimiters, no length was specified,
and a length cannot be determined from a POSITION clause.
Action: If a POSITION clause is specified, adding an end
location to it produces a length specification. This clause
then has the form POSITION(start:end) A length can also
specified after the datatype, as in INTEGER EXTERNAL (6)
Finally, the field could be specified with delimiters, or
the datatype changed to one that has an implied length.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-14270: table is not partitioned by Range or Hash or List method
LSX-00255: mismatched parentheses
ORA-00272: error writing archive log string
NNO-00260: loading configuration data from checkpoint file "string"
ORA-36735: A value exceeded the MAX specification
SQL-02109: Inconsistent host cache. Host reference is out of range
ORA-14616: table is not subpartitioned by List method
ORA-13708: Some snapshots in the range [string, string] were purged before the analysis was complete.
ORA-14624: DEFAULT subpartition must be last subpartition specified
PLS-00243: invalid external type specification for SQLNAME
LPX-00278: invalid ~s proxy "~s"
IMG-00550: invalid scanlineOrder specified
Oracle Errors 
