How to fix the Oracle error SQL*Loader-00289: SQL string for column string occludes SQL string for column string.?

In this post, you’ll learn more about the Oracle ErrorSQL*Loader-00289: SQL string for column string occludes SQL string for column string. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

Reason for the Error SQL*Loader-00289: SQL string for column string occludes SQL string for column string.

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.

How to fix the Error SQL*Loader-00289: SQL string for column string occludes SQL string for column string. ?

You can fix this error in Oracle by following the below steps

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