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

TNS-04047: Invalid specification for destination

1 Answers  


ORA-27214: skgfrsfe: file search failed

1 Answers  


ORA-24361: basic bind call not invoked before invoking advanced bind call

1 Answers  


ORA-02173: invalid option for DROP TABLESPACE

1 Answers  


RMAN-06175: deleted script: string

1 Answers  


ORA-29881: failed to validate indextype

1 Answers  


ORA-25138: %s initialization parameter has been made obsolete

1 Answers  


ORA-01223: RESETLOGS must be specified to set a new database name

1 Answers  


NNL-01052: Server has been running for: string

1 Answers  


ORA-07705: sksaprs: device name buffer too small

1 Answers  


ORA-37035: (XSMLTDCL01) You can only DEFINE SESSION objects in analytic workspace string because it is attached in MULTI mode.

1 Answers  


IMP-00048: mismatched file header

1 Answers  


Categories