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

TNS-00541: underlying transport does not exist.

1 Answers  


ORA-24089: AQ Agent string already exists

1 Answers  


ORA-24045: invalid agent address string, agent address should be of the form [SCHEMA.]NAME[@DATABASE LINK]

1 Answers  


ORA-23600: cannot create PROPAGATION, string already exists

1 Answers  


RMAN-03035: Debugging turned off

1 Answers  


LPX-00223: external entity "~s" found in an attribute value

1 Answers  


ORA-19023: The first argument to UPDATEXML operator has to be an XMLTYPE

1 Answers  


ORA-39961: message specified was not found

1 Answers  


ORA-10654: Table is of type temporary or external

1 Answers  


RMAN-06456: command is obsolete

1 Answers  


ORA-27050: function called with invalid FIB/IOV structure

1 Answers  


ORA-01989: role 'string' not authorized by operating system

1 Answers  


Categories