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

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

Question Posted / guest

2 Answers
31293 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / raju reddy

place the clause TRAILING NULLCOLS in the controlfile, in
the middle like before starting of the column fields.
ex:load data
infile *
insert/append
into
table schemaname."<loc>"
fields terminated by ","
TRAILING NULLCOLS
(<col names>)
begindata
<your data>

Is This Answer Correct ?

11 Yes

3 No

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

Answer / guest

Cause: The logical record ended before all specified fields
were found.

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

Please add more information about this Error

Is This Answer Correct ?

11 Yes

5 No

Post New Answer