Getting Ora-28336 When Doing a DATAPUMP Export as User SYS With TDE Encrypted Tables
(Doc ID 459801.1)
Last updated on OCTOBER 10, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.4 [Release 10.2]Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
You are getting the following type of errors when you try to use expdp :
$ expdp directory=pump tables=system.encryption_test dumpfile=test.dmp encryption_password=test
Export: Release 10.2.0.3.0 - 64bit Production on Monday, 24 September, 2007 12:04:46
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Username: sys as sysdba
Password:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Starting "SYS"."SYS_EXPORT_TABLE_01": sys/******** AS SYSDBA directory=pump tables=system.encryption_test dumpfile=test.dmp encryption_password=********
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-31693: Table data object "SYSTEM"."ENCRYPTION_TEST" failed to load/unload and is being skipped due to error:
ORA-28336: cannot encrypt SYS owned objects
Primary table "SYS"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_TABLE_01 is:
/home/hnapel/pump/test.dmp
Job "SYS"."SYS_EXPORT_TABLE_01" completed with 1 error(s) at 12:05:11
Export: Release 10.2.0.3.0 - 64bit Production on Monday, 24 September, 2007 12:04:46
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Username: sys as sysdba
Password:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Starting "SYS"."SYS_EXPORT_TABLE_01": sys/******** AS SYSDBA directory=pump tables=system.encryption_test dumpfile=test.dmp encryption_password=********
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-31693: Table data object "SYSTEM"."ENCRYPTION_TEST" failed to load/unload and is being skipped due to error:
ORA-28336: cannot encrypt SYS owned objects
Primary table "SYS"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_TABLE_01 is:
/home/hnapel/pump/test.dmp
Job "SYS"."SYS_EXPORT_TABLE_01" completed with 1 error(s) at 12:05:11
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |