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
- 31889 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-00541: underlying transport does not exist.
ORA-19910: can not change recovery target incarnation in controlfile
NNL-00256: Server-generated requests now do not request forwarding
ORA-31438: duplicate change table string
RMAN-06554: WARNING: file string is in backup mode
ORA-06970: X.25 Driver: remote host is unknown
ORA-19300: Error occurred in uri processingstring
ORA-31433: subscriber view does not exist
ORA-16739: log transport service for standby "string" unexpectedly online
ORA-30447: internal data for run number string is inconsistent
NNL-00910: VERSION SKEW responses sent: number
ORA-36154: (XSMXAGGR01) workspace object is not a data variable.
Oracle Errors 
