ORA-28344 Error During Import Of encrypted tables Using Impdp

(Doc ID 2104727.1)

Last updated on MAY 19, 2017

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.1 to 12.1]
Information in this document applies to any platform.


Datapump import of tables from 10g ( into a 12c database ( reports ORA-28344: "fails to decrypt data" for tables with encrypted columns, e.g.:

. . imported "USER"."TABLENAME" 3.161 MB 3773 out of 3774 rows >> some of the rows might not get imported due to this error
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