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-13523: unable to allocate required space for return type

1 Answers  


PLS-00161: Pragma string expects 3rd argument to be an identifier or a string literal

1 Answers  


RMAN-06078: the controlfile is older than datafile string

1 Answers  


SQL*Loader-00472: collections can contain only one non FILLER field specification

1 Answers  


ORA-30951: Element or attribute at Xpath string exceeds maximum length

1 Answers  






RMAN-03033: current log archived

1 Answers  


NNO-00260: loading configuration data from checkpoint file "string"

1 Answers  


ORA-02466: The SIZE and INITRANS options cannot be altered for HASH CLUSTERS.

1 Answers  


ORA-34059: (MSEXECUT12) You cannot delete non session-only dimension values from unique concat dimension workspace object.

1 Answers  


ORA-27155: could not execute file

1 Answers  


NNO-00123: node "string" has no authoritative parent, data ignored

1 Answers  


DRG-13011: language column must be specified when using the multi lexer

1 Answers  


Categories