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-09713: Global hardware clock failure caused instance termination.

1 Answers  


ORA-24406: API mode switch is disallowed when a call is in progress.

1 Answers  


KUP-04047: error parsing record from external data source

1 Answers  


ORA-02175: invalid rollback segment name

1 Answers  


NNL-00800: Query requests received: number

1 Answers  






DRG-11873: System Call Replies

1 Answers  


PLS-01705: table specified by a cursor not updatable if cursor specification has a UNION or ORDER_BY

1 Answers  


NNL-00238: Statistic counter reset interval is now string

1 Answers  


ORA-36670: (XSDPART08) workspace object is an INTEGER or NTEXT dimension, or contains an INTEGER or NTEXT dimension. INTEGER and NTEXT dimensions cannot be used as partition dimensions.

1 Answers  


ORA-16181: SGA specified for Logical Standby is too large

1 Answers  


ORA-31155: attribute string not in XDB namespace

1 Answers  


ORA-19025: EXTRACTVALUE returns value of only one node

1 Answers  


Categories