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 |
ORA-24274: no row exists in the string table for these parameters
ORA-31628: error getting worker process exception
ORA-12826: hung parallel query server was killed
ORA-02084: database name is missing a component
ORA-02240: invalid value for OBJNO or TABNO
ORA-29954: domain index partition is marked LOADING/FAILED/UNUSABLE
DRG-12504: stoplist string does not exist
ORA-02850: File is closed
ORA-02178: correct syntax is: SET TRANSACTION READ { ONLY | WRITE }
ORA-14641: STORE-IN clause can be specified only for a Hash, Composite Range Hash table/partition
ORA-40216: feature not supported
ORA-02191: correct syntax is: SET TRANSACTION USE ROLLBACK SEGMENT <rbs>