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
- 31892 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-27503: IPC error attempting to cancel request
NNO-00626: cannot enable DEFAULT-FORWARDERS-ONLY mode, no default forwarders exist
ORA-02181: invalid option to ROLLBACK WORK
ORA-30556: functional index is defined on the column to be modified
ORA-03205: partition name is required when partitioned type is specified
SQL*Loader-00408: Physical record stack overflow
PLS-00521: ORDER methods must be declared with 1 (one) parameter in addition to (optional) SELF.
ORA-33003: (XSAGDIMDROP) workspace object, to be transformed during data load, must be a base dimension and not otherwise referenced in the AGGMAP.
ORA-02785: Invalid shared memory buffer size
ORA-13026: unknown element type for element string.string.string
NCR-04009: NCRR: Object exists
PLS-00705: exception 'string' used in expression requiring return type
Oracle Errors 
