ORA-28344 Error During Import Of encrypted tables Using Impdp
Last updated on MAY 19, 2017
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 to 184.108.40.206 [Release 10.1 to 12.1]
Information in this document applies to any platform.
Datapump import of tables from 10g (10.2.0.4) into a 12c database (220.127.116.11) reports ORA-28344: "fails to decrypt data" for tables with encrypted columns, e.g.:
1 row(s) were rejected with the following error:
ORA-28344: fails to decrypt data
The DDL of the table shows that the column is encrypted as below:
The encryption wallet is open in both source and destination and no issues are found related to security or wallets.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms