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
- 31918 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-27509: IPC error receiving a message
CLSR-00531: Can not get primary group name
DRG-11211: charset column must be a char, varchar, or varchar2 type
ORA-23467: flavor lacks object "string"."string"
ORA-19665: size string in file header does not match actual file size of string
ORA-06319: IPA: Remote maximum number of users exceeded
ORA-07305: ksmcsg: illegal database buffer size.
ORA-19638: file string is not current enough to apply this incremental backup
ORA-09807: Conversion of label from string to binary failed.
ORA-28552: pass-through SQL: call flow error
ORA-10580: Can not modify datafile header during test recovery
LPX-00312: cannot construct XML PI with content: ~S
Oracle Errors 
