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

TNS-12660: Encryption or crypto-checksumming parameters incompatible

1 Answers  


NNL-00907: NOT ALLOWED responses sent: number

1 Answers  


ORA-25007: functions or methods not allowed in WHEN clause

1 Answers  


ORA-06254: NETNTT: cannot share connection to cube

1 Answers  


ORA-01568: cannot set space quota on PUBLIC

1 Answers  






ORA-09882: sstasfre/sstasdel: shmctl error, unable to remove tas shm page

1 Answers  


RMAN-20218: datafile not found in recovery catalog

1 Answers  


ORA-01627: rollback segment number 'string' is not online

1 Answers  


KUP-02004: quoted string too big

1 Answers  


TNS-12571: TNS:packet writer failure

1 Answers  


ORA-26059: Data is too large for column string

1 Answers  


ORA-19582: archivelog file header validation for string failed

1 Answers  


Categories