Skip to content

Important Commands related to Transparent Data Encryption (TDE)

Below are some of the frequently used commands related to Transparent Data Encryption (TDE)

— TO FIND WHICH ALL TABLESPACES ARE ENCRYPTED

SQL> select * from dba_tablespaces where encrypted='YES';

OR

SQL> select * from V$ENCRYPTED_TABLESPACES;

— TO FIND WHICH ALL TABLES ARE ENCRYPTED

SQL> select * from dba_tables where tablespace_name in (select tablespace_name from dba_tablespaces where encrypted='YES');

 

— TO FIND NAMES OF ALL OBJECTS (TABLES, INDEXES ETC) WHICH ARE ENCRYPTED

SQL> select segment_name,segment_type from dba_segments where tablespace_name in (select tablespace_name from dba_tablespaces where encrypted='YES') order by 2;

 

— TO FIND COUNT OF ALL OBJECTS (TABLES, INDEXES ETC) WHICH ARE ENCRYPTED

SQL> select segment_type,count(*) from dBA_segments where tablespace_name in (select tablespace_name from dba_tablespaces where encrypted='YES') group by segment_type;

 

— TO FIND DETAILS OF WALLET LOCATION AND STATUS:

SQL> select * from v$encryption_wallet;

 

— TO FIND DETAILS OF WALLET LOCATION AND STATUS ON RAC SYSTEM:

SQL> select * from gv$encryption_wallet;

 

— TO OPEN THE WALLET MANUALLY (11g)

SQL> ALTER SYSTEM SET ENCRYPTION WALLET OPEN IDENTIFIED BY "password";

 

– TO CLOSE THE WALLET MANUALLY (11g)

SQL> ALTER SYSTEM SET ENCRYPTION WALLET CLOSE IDENTIFIED BY "password";

 

[Post Views: 137]

Brijesh Gogia

I’m an experienced Oracle Applications DBA with more than a decade of full-time DBA experience. I have gained a wide knowledge of the Oracle software stack and have worked on several big projects for multi-national companies. I enjoy working with the leading-edge technology and have passion for database performance and stability. Thankfully my work allows me time for researching new technologies (and to write about them).
  
You can connect with me on LinkedIn.

Be First to Comment

Leave a Reply

Required fields are marked *