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...
top of page
bottom of page
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