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

ORA-24368: OCI mutex counter non-zero when freeing a handle

1 Answers  


IMG-00521: invalid value for dataOffset

1 Answers  


ORA-01792: maximum number of columns in a table or view is 1000

1 Answers  


ORA-12696: Double Encryption Turned On, login disallowed

1 Answers  


ORA-36820: (XSLMINFO00) The LIMITMAPINFO function encountered an error while parsing the LIMITMAP.

1 Answers  






PCC-02441: Number of attributes does not match number of host variables

1 Answers  


ORA-28181: proxy 'string' failed to enable one or more of the specified initial roles for client 'string'

1 Answers  


TNS-04084: WARNING: Non-reloadable parameters have retained their values.

1 Answers  


ORA-27088: unable to get file status

1 Answers  


ORA-28658: This operation is supported only for Index-Organized tables

1 Answers  


ORA-25184: column name expected

1 Answers  


ORA-24124: invalid ACTION parameter passed to DBMS_REPAIR.string procedure

1 Answers  


Categories