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

NNL-00930: Requests refused, unknown data type: number

1 Answers  


ORA-23401: materialized view "string"."string" does not exist

1 Answers  


ORA-08463: overflow converting decimal number to Oracle number

1 Answers  


KUP-04056: internal error: OCI error while fetching record: number

1 Answers  


UDE-00002: invalid username or password

1 Answers  






TNS-01200: The listener must be suid root

1 Answers  


ORA-12538: TNS:no such protocol adapter

1 Answers  


IMG-00003: exhausted memory while processing image

1 Answers  


ORA-27025: skgfqsbi: invalid media manager context area size

1 Answers  


TNS-00264: Navigator: Failed to reload configuration data

1 Answers  


ORA-16011: Archivelog Remote File Server process in Error state

1 Answers  


ORA-01606: gc_files_to_locks not identical to that of another mounted instance

1 Answers  


Categories