SQL*Loader-00289: SQL string for column string occludes SQL
string for column string.



SQL*Loader-00289: SQL string for column string occludes SQL string for column string...

Answer / guest

Cause: A SQL string has been associated with both a column
object and one of its attributes in the control file.
Because the SQL string of the column object will replace the
entire column object in the VALUE clause of the INSERT
statement, the SQL string of the attribute is ignored. This
could cause unexpected or incorrect values to be loaded.

Action: Correct the control file so that only the column
object or its attribute has a SQL string, but not both.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-31507: %s parameter value longer than maximum length string

1 Answers  


ORA-29930: COMPUTE ANCILLARY DATA specified without the INDEX CONTEXT clause

1 Answers  


NNL-00952: Cache lookup failures: number

1 Answers  


TNS-12196: TNS:received an error from TNS

1 Answers  


ORA-14160: this physical attribute may not be specified for a table subpartition

1 Answers  






ORA-28669: bitmap index can not be created on an IOT with no mapping table

1 Answers  


RMAN-08071: channel string: deleting archive log(s)

1 Answers  


ORA-13854: Tracing for service(module/action) string on instance string is not enabled

1 Answers  


ORA-01598: rollback segment 'string' is not online

1 Answers  


SQL*Loader-00264: File mode token string parsed but ignored

1 Answers  


ORA-29399: user string does not have privilege to switch to consumer group string

1 Answers  


ORA-29926: association already defined for the object

1 Answers  


Categories