Getting Ora-28336 When Doing a DATAPUMP Export as User SYS With TDE Encrypted Tables (Doc ID 459801.1)

Last updated on NOVEMBER 03, 2015

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4 - Release: 10.2 to 10.2
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
Master 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

Cause

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