My Oracle Support Banner

How To Simply Verify If Table Data Is Actually Encrypted With TDE (Transparent Data Encryption) (Doc ID 2509659.1)

Last updated on FEBRUARY 20, 2020

Applies to:

Oracle Database - Enterprise Edition - Version and later
Advanced Networking Option - Version and later
Information in this document applies to any platform.


When using TDE (Transparent Data Encryption), specified data is encrypted transparently in the database.

With TDE the user or the application does not need to be aware of the encryption,
but as a database administrator, there may be times when you wish to
verify that the data is actually encrypted.

This document will describe how to check whether the data that is expected to be encrypted is actually encrypted in the data file.



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.