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

RMAN-04020: target database name "string" does not match channel's name: "string"

1 Answers  


NNC-00413: general failure

1 Answers  


ORA-06033: NETDNT: connect failed, partner rejected connection

1 Answers  


NNL-01052: Server has been running for: string

1 Answers  


ORA-33625: (FRASSIGN02) You cannot use the APPEND keyword with concat dimension workspace object.

1 Answers  


ORA-02306: cannot create a type that already has valid dependent(s)

1 Answers  


ORA-07632: smsrcx: $DELTVA failure

1 Answers  


RMAN-08115: channel string: restoring SPFILE

1 Answers  


ORA-38438: getVarchar not possible due to "string" datatype in the attribute set

1 Answers  


ORA-01339: logfile is too old

1 Answers  


ORA-38489: predicate table creation failed due to: ORAstring

1 Answers  


ORA-16591: unknown field "string" in document

1 Answers  


Categories