How to fix the Oracle error ORA-12445: cannot change HIDDEN property of column?

In this post, you’ll learn more about the Oracle ErrorORA-12445: cannot change HIDDEN property of column with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-12445: cannot change HIDDEN property of column

Reason for the Error ORA-12445: cannot change HIDDEN property of column

You tried to specify a different HIDE option for a table with an existing policy column.

How to fix the Error ORA-12445: cannot change HIDDEN property of column ?

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

Drop the column from the table and reapply the policy with the new HIDE option.