SQL*Loader-00622: Column not found before end of logical
record (use TRAILING NULLCOLS)
- 2 Answers
- 30548 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 |
ORA-08189: cannot flashback the table because row movement is not enabled
ORA-02303: cannot drop or replace a type with type or table dependents
PCB-00300: Datatype for host variable not supported by ANSI "string"
ORA-08468: mask option string is not supported
EXP-00013: respond with either 'Y', 'N', RETURN or '.' to quit
ORA-25020: renaming system triggers is not allowed
PCC-02109: SQLCHECK=NONE is no longer supported.. using SYNTAX
TNS-00079: * log_off - ask process_name to turn logging off
NNL-00955: Hash tables enlarged: number
RMAN-03028: fatal error code for command string : number
NNL-00245: General request processing is currently enabled
ORA-27050: function called with invalid FIB/IOV structure
Oracle Errors 
