Impdp reported ORA-28336: cannot encrypt SYS owned objects
(Doc ID 1356606.1)
Last updated on APRIL 03, 2020
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.2 [Release 10.2]
Information in this document applies to any platform.
- Data Pump Import (impdp) reports the following errors while importing a table which contains an encrypted column:
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
ORA-31693: Table data object "TEST"."T1" failed to load/unload and is being skipped due to error:
ORA-28336: cannot encrypt SYS owned objects
- This occurs even when the wallet has been created with correct key, wallet is open, sqlnet.ora entries correct. Import parameter file has correct key. Attempted import using SYSTEM, schema owner and SYS, all fail.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document