DBA Hub

📋Steps in this guide1/1

Disable TDE In Oracle 12c

Please Note : Don't use this on a production database. Any problems that arise as a result of such activities will not be resolved by the Oracle

oracle configurationintermediate
by OracleDba
13 views
1

Overview

Please Note : Don’t use this on a production database. Any problems that arise as a result of such activities will not be resolved by the Oracle Support/Development team. Please Note : Now TDE has been disabled. Now if you want to enable TDE again, then restore the wallet files and open the key.

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
SQL> select owner,table_name,column_name,encryption_alg from dba_encrypted_columns;

OWNER TABLE_NAME COLUMN_NAME ENCRYPTION_ALG
----- ------------ ------------ -----------------------------
AMAR EMPLOYEE SALARY AES 192 bits key


SQL> alter table AMAR.employee modify( salary decrypt);

Table altered.

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

No rows selected

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

SEGMENT_NAME TABLESPACE_NAME
---------------------------------------- ------------------------------
TEST_TABLE TEST_ENCRY



SQL> alter table TEST_TABLE move tablespace users;

Table altered.

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

no rows selected



SQL> drop tablespace test_encry including contents and datafiles;

Tablespace dropped.

SQL> alter system switch logfile;
System altered.

SQL> /
/
/

System altered.

SQL>
System altered.

SQL>ADMINISTER KEY MANAGEMENT SET KEYSTORE close;


cd /media/sf_stuff/wallet
mv * backup/

SQL> startup force

Comments (0)

Please to add comments

No comments yet. Be the first to comment!