SQL*Loader-00402: Unable to determine length of column
string from specification
- 1 Answers
- 2751 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-13504: No SYSAUX datafile clause specified
NNL-00984: Name-to-hint translations failed: number
ORA-38901: column "string" of table "string" must be one of the first "number" columns
PCC-00126: Could not find or open system configuration file
ORA-31660: metadata filter name can not be defaulted
LPX-00007: unexpected end-of-file encountered
O2U-00210: Unable to allocate memory
ORA-24853: failed to connect thread to shared subsystem
TNS-01073: Listening on: string
SQL*Loader-00518: Error reassembling file name (string)
ORA-30747: cannot create substitutable tables or columns of non final type string.string
ORA-00056: DDL lock on object 'string.string' is already held in an incompatible mode
Oracle Errors 
