How to check if TDE or TSE is enabled in Oracle Database


If we want to find if TDE or TSE is enabled in database we can use below queries.

TDE is encryption is table column level
TSE us encryption in table space level

To check if your table space is encrypted, run below query
SQL> SELECT tablespace_name, encrypted, status FROM dba_tablespaces where tablespace_name = "<TS name>"

To check if you have encrypted columns use
SQL> SELECT * FROM dba_encrypted_columns;







If you like please follow and comment