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';

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";

Author
Recent Posts

Brijesh Gogia

I’m an experienced Cloud/Oracle Applications/DBA Architect with more than 15 years of full-time DBA/Architect experience. I have gained wide knowledge on Oracle and Non-Oracle software stack running on-prem and on Cloud and have worked on several big projects for multi-national companies. I enjoy working with leading-edge technology and have a passion for Cloud architecture, automation, database performance, and stability. Thankfully my work allows me time for researching new technologies (and to write about them).

Important Commands related to Transparent Data Encryption (TDE)

Related posts: