How to fix the Oracle error ORA-26788: The column string is not encrypted in the local database.?

In this post, you’ll learn more about the Oracle ErrorORA-26788: The column string is not encrypted in the local database. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-26788: The column string is not encrypted in the local database.

Reason for the Error ORA-26788: The column string is not encrypted in the local database.

The column in the destination database is NOT encrypted while it is encrypted in the source database.

How to fix the Error ORA-26788: The column string is not encrypted in the local database. ?

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

Set the corresponding column property in the destination database to ‘encrypted’ or change the apply parameter, PRESERVE_ENCRYPTED_COLS, to ‘N’ to supress the error.