SQL*Loader-00402: Unable to determine length of column
string from specification



SQL*Loader-00402: Unable to determine length of column string from specification..

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

Post New Answer

More Oracle Errors Interview Questions

ORA-31438: duplicate change table string

1 Answers  


RMAN-08019: channel string: restoring datafile string

1 Answers  


RMAN-08122: keep attributes for the backup are changed

1 Answers  


PCC-02357: Function calls may not be used as host variable expressions

1 Answers  


ORA-31202: DBMS_LDAP: LDAP client/server error: string

1 Answers  






DRG-12301: index does not exist in index set

1 Answers  


RMAN-08042: channel string: copied standby controlfile

1 Answers  


PCC-02420: Incomplete (or missing) type specification

1 Answers  


ORA-25958: join index where clause predicate may only contain column references

1 Answers  


ORA-13379: invalid index for sub-element to be extracted

1 Answers  


RMAN-06904: backup of log thread number seq number lowscn string was cancelled

1 Answers  


ORA-09835: addCallback: callback port is already in a set.

1 Answers  


Categories