SQL*Loader-00640: Variable length field was truncated.



SQL*Loader-00640: Variable length field was truncated...

Answer / guest

Cause: The end of the logical record was encountered before
the end of a variable length field. The length of each
variable-length field is embedded in the field, so
SQL*Loader knows that more data should have been present.

Action: Check the data for inadvertent truncation and verify
the SQL*Loader control file specifications against the log
file; the field may be starting in the wrong place.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

DRG-11832: Request Entity Too Large

1 Answers  


IMG-02008: 2FF08 - color histogram feature cannot be determined

1 Answers  


ORA-37010: (XSACQUIRE_DIFFAW) When using CONSITENT WITH clause, all objects must come from the same analytic workspace.

1 Answers  


ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified

1 Answers  


ORA-38462: invalid attribute list

1 Answers  






SQL*Loader-00628: Character set conversion error.

1 Answers  


ORA-27206: requested file not found in media management catalog

1 Answers  


PLS-00354: username must be a simple identifier

1 Answers  


PCB-00556: Unrecoverable error. Fix previous errors and re-precompile

1 Answers  


ORA-16185: REMOTE_ARCHIVE_ENABLE and LOG_ARCHIVE_CONFIG mutually exclusive

1 Answers  


NNL-00986: Reforwarded requests expired: number

1 Answers  


ORA-25268: didnt dequeue in browse mode with get signature option

1 Answers  


Categories