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-14012: resulting partition name conflicts with that of an existing partition

1 Answers  


ORA-22320: missing user version string

1 Answers  


ORA-12464: invalid characters in label component string

1 Answers  


ORA-30567: name already used by an existing log group

1 Answers  


NID-00500: Keyword Description (Default)

1 Answers  


ORA-01061: cannot start up a V8 server using a V7 client application

1 Answers  


ORA-10563: Test recovery had to corrupt data block (file# string, block# string) in order to proceed

1 Answers  


ORA-39021: Database compatibility version string is not supported.

1 Answers  


ORA-39142: incompatible version number string in dump file "string"

1 Answers  


ORA-12057: materialized view "string"."string" is INVALID and must complete refresh

1 Answers  


ORA-23361: materialized view "string" does not exist at master site

1 Answers  


ORA-27459: A program of type EXECUTABLE must have character-only arguments.

1 Answers  


Categories