SQL*Loader-00622: Column not found before end of logical
record (use TRAILING NULLCOLS)
Answers were Sorted based on User's Feedback
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 |
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 |
PCC-00060: Both CURSOR and STATEMENT have AT clauses at line number of file string.
PCC-02041: CMD-LINE: Option does not exist:
ORA-38480: creation of system trigger EXPFIL_ALTEREXPTAB_MAINT failed.
ORA-21526: initialization failed
SQL*Loader-00601: For INSERT option, table must be empty. Error on table string
ORA-25264: cant get signature for this queue
PCB-00576: PLS-number: string
QSM-02146: see the reason why REFRESH_FAST_AFTER_INSERT is disabled
KUP-03001: fatal error during library cache pre-loading
RMAN-06436: enter DROP CATALOG command again to confirm catalog removal
ORA-02337: not an object type column
ORA-12509: TNS:listener failed to redirect client to service handler