How to fix the Oracle error KUP-04055: column string is both a field in the data file and a column transform?

In this post, you’ll learn more about the Oracle ErrorKUP-04055: column string is both a field in the data file and a column transform with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

KUP-04055: column string is both a field in the data file and a column transform

Reason for the Error KUP-04055: column string is both a field in the data file and a column transform

The specified column was in the list of fields in the data file and in the list of column transforms. The column should be in one list or the other, but not both.

How to fix the Error KUP-04055: column string is both a field in the data file and a column transform ?

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

Determine whether the value for the field in the data file or the value for the field in the column transform should be loaded in to the table. If the value for the data file is to be loaded, then remove the column transform. If the value for the column transform is to be loaded, then rename the field in the data file so that it does not match the name of a field in the table.