My Oracle Support Banner

dbms_metadata.get_ddl Doesn't Show Encryption (Encrypted in dba_tablespaces Shows 'NO' ) for Offline Encrypted Tablespace (Doc ID 2440096.1)

Last updated on FEBRUARY 04, 2020

Applies to:

Advanced Networking Option - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Encryption status shows 'NO', even after successful offline tablespace TDE encryption.

All the datafiles of an tablespace were encrypted by Offline TDE encryption (as explained at Whitepaper) , but still encrypted column in dba_tablespaces shows NO.

select TABLESPACE_NAME,STATUS,ENCRYPTED from dba_tablespaces;
TABLESPACE_NAME STATUS ENC
------------------------------ --------- ---
DATA1 ONLINE NO
DATA2 ONLINE NO

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


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