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
- 32018 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-02461: Inappropriate use of the INDEX option
PCC-01002: Invalid character "character" in indicator area at line number in file string
NZE-29096: The given length is incorrect.
DRG-12405: error occurred processing CTX REDIRECT or CTX LABEL tag
ORA-19808: recovery destination parameter mismatch
ORA-12019: master table is a synonym to a remote object
NNL-00506: reset_stats [<server_list>] : reset Names server statistics
ORA-16722: unable to set LOG_ARCHIVE_DEST_STATE_n parameters
ORA-13462: invalid blocking specification
ORA-19803: Parameter DB_RECOVERY_FILE_DEST_SIZE is out of range (1 - string)
QSM-01126: query rewritten with set operator materialized view, string
EXP-00026: conflicting modes specified
Oracle Errors 
