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
- 31789 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 |
NID-00354: Instance shut down
ORA-12319: database (link name string) is already open
RMAN-06534: KEEP ... CONSISTENT option is not supported
ORA-22608: cannot add an attribute to the already generated image handle
ORA-09820: Conversion of class string to numeric representation failed.
VID-00705: unsupported input format
PLS-01414: Use of qualified expression here
EXP-00032: Non-DBAs may not export other users
PLS-01406: An identifier has been found that is considered a keyword in ANSI's grammar but not in PL/SQL's
ORA-30019: Illegal rollback Segment operation in Automatic Undo mode
TNS-00277: Navigator: Request Failed
ORA-23323: parameter length exceeds deferred RPC limits
Oracle Errors 
