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-23345: table "string"."string" not registered to collect statistics

1 Answers  


TNS-04015: Current instance string is not yet started

1 Answers  


ORA-06035: NETDNT: connect failed, insufficient resources

1 Answers  


TNS-00314: Protocol Adapter Errors: number,number

1 Answers  


ORA-22976: incorrect number of arguments to MAKE_REF

1 Answers  






ORA-13001: dimensions mismatch error

1 Answers  


PLS-00600: SAMPLE cannot be applied to a remote object

1 Answers  


ORA-25403: could not reconnect

1 Answers  


ORA-06548: no more rows needed

1 Answers  


ORA-16784: The database object name given in property Dependency is incorrect.

1 Answers  


ORA-07600: slkmnm: $GETSYIW failure

1 Answers  


ORA-13641: Task cannot be interrupted yet. You may cancel it instead.

1 Answers  


Categories