Interested to Buy Any Domain ? << Click Here >> for more details...
SQL*Loader-00622: Column not found before end of logical
record (use TRAILING NULLCOLS)
- 2 Answers
- 31770 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 |
RMAN-06492: controlfile autobackup format "string" must specify a "string" format specifier
ORA-38608: FI itemset minimum-length(string) should not be greater than maximum length(string)
ORA-02709: osnpop: pipe creation failed
ORA-01488: invalid nibble or byte in the input data
TNS-00205: Turning off tracing in intlsnr
NMP-00006: uninitialized SNMP context
ORA-13483: insufficient memory for the specified GeoRaster data
ORA-22876: this user-defined type is not allowed or it cannot be used in this context
ORA-13436: GeoRaster metadata dimensionSize error
ORA-23443: missing template parameter
ORA-13290: the specified unit is not supported
ORA-15197: suppressing string additional ASM messages
Oracle Errors 
