SQL*Loader-00415: column string in table string cannot use
and be the object of an SDF or LOBFILE
- 1 Answers
- 2930 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 |
ORA-12156: TNS:tried to reset line from incorrect state
RMAN-03000: recovery manager compiler component initialization failed
ORA-09930: LUB of two labels is invalid
ORA-22899: cannot specify both scope and rowid constraint on ref column
ORA-00074: no process has been specified
ORA-02827: Invalid file number
SQL*Loader-00557: unable to allocate memory
DRG-11512: bad syntax for thesaurus load file at line string
PCB-00402: Pseudo-text not properly terminated
RMAN-05001: auxiliary filename string conflicts with a file used by the target database
ORA-40103: invalid case-id column: string
LFI-00140: Invalid option string were specified on input-output file.
Oracle Errors 
