Oracle Error SQL*Loader-00622: Column not found before end of logical record (use TRAILING NULLCOLS)

Oracle Error Message

SQL*Loader-00622: Column not found before end of logical record (use TRAILING NULLCOLS)

Reason for the Error

The logical record ended before all specified fields were found.

Solution

If the missing fields should be loaded as null, use the TRAILING NULLCOLS clause. Otherwise, correct the data.

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

Oracle Error Message ORA-24328: illegal attribute value Reason for the Error The attribute value passed in is illegal. Solution Consult...
Oracle Error Message ORA-01346: LogMiner processed redo beyond specified reset log scn Reason for the Error LogMiner has detected a...
Oracle Error Message ORA-13241: specified dimensionality does not match that of the data Reason for the Error An error occurred...