SQL*Loader-00415: column string in table string cannot use
and be the object of an SDF or LOBFILE
- 1 Answers
- 2766 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: The named column is identified as the target of a
secondary data file (SDF) or LOBFILE clause. However, the
column also gets it's value from an SDF or LOBFILE. If a
field name is named in an SDF or LOBFILE clause, then that
field cannot have an SDF or LOBFILE clause.
Action: Verify that the SDF and LOBFILE clauses in the
SQL*Loader control file name the correct fields. Also verify
that the SDF and LOBFILE clauses are specified for the
correct field.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
AUD-00704: invalid input format
PLS-00525: Within SQL statements, only equality comparisons of objects are allowed without a map or order function.
NNL-00256: Server-generated requests now do not request forwarding
RMAN-06155: validation failed for controlfile copy
LSX-00141: ID type may only be used in attributes
ORA-16402: ONDEMAND archival requires FAL_CLIENT and FAL_SERVER support
ORA-38426: attribute set assigned to an expression set may not be dropped
ORA-30105: 'string' is not a legal boolean for 'string'
ORA-03242: Tablespace migration retried 500 times
QSM-02084: DISTINCT clause on a duplicate sensitive aggregate function
KUP-04003: error while closing file string
ORA-01626: rollback segment number 'string' cannot handle more transactions
Oracle Errors 
