Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-12642: No session key

1 Answers  


NNO-00320: missing server name parameter

1 Answers  


ORA-13341: a line geometry has fewer than two coordinates

1 Answers  


NNL-00343: Log file name is now string

1 Answers  


ORA-16735: Error executing dbms_logstdby.unskip_error procedure

1 Answers  






ORA-09824: Unable to enable allowmacaccess privilege.

1 Answers  


QSM-01102: materialized view, string, requires join back to table, string, on column, string

1 Answers  


ORA-02145: missing STORAGE option

1 Answers   Oracle,


TNS-02520: encryption/crypto-checksumming: no Diffie-Hellman seed

1 Answers  


PLS-00553: character set name is not recognized

1 Answers  


ORA-28559: FDS_CLASS_NAME is string, FDS_INST_NAME is string

1 Answers  


KUP-03022: lob data could not be found for field string

1 Answers  






Categories