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-24002: QUEUE_TABLE string does not exist

1 Answers  


ORA-02711: osnpvalid: write to validation channel failed

1 Answers  


ORA-08237: smsget: SGA region not yet created

1 Answers  


ORA-32632: incorrect subquery in MODEL FOR cell index

1 Answers  


ORA-30379: query txt not specified

1 Answers  






O2U-00211: A type without attributes was translated

1 Answers  


ORA-37134: (XSCCOMP09) You cannot add new values to workspace object because it includes positions for precomputed aggregate values.

1 Answers  


QSM-00792: the specified SQL statement cannot be stored in the workload because one or more tables have missing statistics

1 Answers  


QSM-00796: the specified SQL statement cannot be stored in the workload because table string does not have valid statistics

1 Answers  


LFI-00133: Trying to create file string that already exists.

1 Answers  


NNO-00635: warning: ignoring duplicate forwarder "string"

1 Answers  


KUP-04083: no directory object specified in LOBFILE clause for column string

1 Answers  


Categories