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

Oracle Error Message

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

Reason for the Error

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

Solution

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.