SQL*Loader-00622: Column not found before end of logical
record (use TRAILING NULLCOLS)
- 2 Answers
- 31334 Views
- I also Faced
- E-Mail Answers
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 |
TNS-04047: Invalid specification for destination
ORA-27214: skgfrsfe: file search failed
ORA-24361: basic bind call not invoked before invoking advanced bind call
ORA-02173: invalid option for DROP TABLESPACE
RMAN-06175: deleted script: string
ORA-29881: failed to validate indextype
ORA-25138: %s initialization parameter has been made obsolete
ORA-01223: RESETLOGS must be specified to set a new database name
NNL-01052: Server has been running for: string
ORA-07705: sksaprs: device name buffer too small
ORA-37035: (XSMLTDCL01) You can only DEFINE SESSION objects in analytic workspace string because it is attached in MULTI mode.
IMP-00048: mismatched file header
Oracle Errors 
