Impdp reported ORA-28336: cannot encrypt SYS owned objects
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.2 - Release: 10.2 to 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms