Home » Oracle » Oracle Database » How to check encrypted tablespace in the Database

How to check encrypted tablespace in the Database

This post will discuss How to check encrypted tablespace in the Database. This question will be useful when you are checking the security of the database.

What is a TDE wallet?

Transparent Data Encryption (TDE) is a feature available in Oracle Database for securing sensitive data at the storage level. The TDE Wallet is a critical component within this architecture, used to securely store the master encryption keys. The wallet facilitates the encryption and decryption processes, making it pivotal for database security.

How to check encrypted tablespace in the Database

Here is the query that can be used on How to check encrypted tablespace in the Database

select t.name,e.encryptionalg,e.encyptedts,e.status from v$encrypted_tablespaces e,v$tablespace t where t.ts#=e.ts#(+);

How to check individual datafile encryption within the tablespace

We can further check the datafile encryption status of the above tablespaces using the below query. These queries are Valid from 19c onwards only

select name, encrypted from v$datafile_header  where tablespace_name like '&1';

We can find the count of the datafiles that are not encrypted in the particular tablespace using the below query. These queries are Valid from 19c onwards only

select count(*) from v$datafile_header  where tablespace_name like '&1' and encrypted='NO';

We can find the count of the datafiles that are encrypted in the particular tablespace using the below query. These queries are Valid from 19c onwards only

select count(*) from v$datafile_header  where tablespace_name like '&1' and encrypted='YES';

I hope you find these queries useful

Related Articles

How To Restore TDE Wallet Files From Backup in Oracle Database
how to check if oracle database is encrypted
TDE encryption in Oracle 12c step by step
TDE encryption in oracle 11g step by step
How to Configure Auto Login TDE Wallet
How To Export TDE Master Encryption Key
https://docs.oracle.com/en/database/oracle/oracle-database/18/asoag/managing-keystore-and-tde-master-encryption-key.html

See also  ORA-00904: invalid identifier in Oracle

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top