To see this working, head to your live site.

Completely removing tde from oracle 12c database

Hello everyone, how do i completely remove tde after decrypting tablespace. i want to remove encryption keys and wallet and remain with database without any encryption wallet. I thank you in advance for assistance on this...

1 answer0 replies

1 Comment

Piyush Ranjan

Jul 02, 2022

•

Find the encrypted table columns and decrypt them.

SQL> select owner,table_name,column_name,encryption_alg from dba_encrypted_columns;

SQL> alter table "OWNER.TABLE_NAME" modify( salary decrypt);

Table altered.

SQL> select owner,table_name,column_name,encryption_alg from dba_encrypted_columns;

How do I find the encrypted tablespace in my database?

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

SQL> alter table enc_table move tablespace users;

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

SQL> drop tablespace test_encry including contents and datafiles;

Switch between different log files multiple times.

SQL> alter system switch logfile;

Restart the database, transfer the wallet files, then close the wallet:

SQL>ADMINISTER KEY MANAGEMENT SET KEYSTORE close;

cd /u01/app/oracle/wallet
mv * backup/

SQL> startup