My Oracle Support Banner

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 to [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.


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 - 64bit Production on Monday, 24 September, 2007 12:04:46

Copyright (c) 2003, 2005, Oracle. All rights reserved.

Username: sys as sysdba

Connected to: Oracle Database 10g Enterprise Edition Release - 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:
Job "SYS"."SYS_EXPORT_TABLE_01" completed with 1 error(s) at 12:05:11




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.