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

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

More Oracle Errors Interview Questions

ORA-24274: no row exists in the string table for these parameters

1 Answers  


ORA-31628: error getting worker process exception

1 Answers  


ORA-12826: hung parallel query server was killed

1 Answers  


ORA-02084: database name is missing a component

1 Answers  


ORA-02240: invalid value for OBJNO or TABNO

1 Answers  






ORA-29954: domain index partition is marked LOADING/FAILED/UNUSABLE

1 Answers  


DRG-12504: stoplist string does not exist

1 Answers  


ORA-02850: File is closed

1 Answers  


ORA-02178: correct syntax is: SET TRANSACTION READ { ONLY | WRITE }

1 Answers  


ORA-14641: STORE-IN clause can be specified only for a Hash, Composite Range Hash table/partition

1 Answers  


ORA-40216: feature not supported

1 Answers  


ORA-02191: correct syntax is: SET TRANSACTION USE ROLLBACK SEGMENT <rbs>

1 Answers  


Categories