Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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 ?    10 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

QSM-01572: equivalence, string, and query have different joins between tables, string

1 Answers  


PCC-00037: Unable to log on to ORACLE with "string". ORACLE error number: number

1 Answers  


ORA-24354: number fetched too large to fit in COBOL display type buffer.

1 Answers  


ORA-14606: Tablespace was specified for previous subpartitions in template but is not specified for string

1 Answers  


ORA-19636: archivelog thread string sequence string already included

1 Answers  






ORA-29276: transfer timeout

1 Answers  


PLS-00993: Cursor Variables cannot be passed as RPC arguments or results

1 Answers  


ORA-29379: resource plan string is involved in a loop in top-plan string

1 Answers  


ORA-08103: object no longer exists

1 Answers  


LPX-00201: unknown encoding "~s"

1 Answers  


ORA-14021: MAXVALUE must be specified for all columns

1 Answers  


QSM-02021: set operator encountered in mv

1 Answers  






Categories