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
- 31923 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-14071: invalid option for an index used to enforce a constraint
LFI-01507: fwrite() failed(OSD return value = string) in string.
ORA-38448: Indexing predicates with "string" operator is not supported.
RMAN-06747: at least 1 channel of tertiary storage must be allocated to execute this command
NNL-00901: CONTENT ERROR responses sent: number
NZE-28808: Cannot retrieve method information from the configuration file.
ORA-08413: invalid compiler type in FORMAT parameter at string
ORA-30163: The thread safety initialization failed
ORA-27451: %s cannot be NULL
ORA-32162: Read/Write SQL method not registered
O2F-00321: Error opening the OUTTYPE file for writing
ORA-22609: error string during initialization of FDO
Oracle Errors 
