DBA Hub

📋Steps in this guide1/1

encrypt or decrypt a column

-- Before encrypting decrypting make sure TDE is enabled in database. -- Encrypt a column

oracle configurationintermediate
by OracleDba
12 views
1

encrypt or decrypt a column

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
-- Before encrypting decrypting make sure TDE is enabled in database.
-- Encrypt a column
alter table SCOTT.EMP modify ( emp_name encrypt);
alter table SCOTT.EMP modify ( emp_name encrypt using 'AES256');
-- Decrypt a column:
alter table SCOTT.EMP modify ( emp_name decrypt);
NOTE - This activity will take time, according to the table size and it might block other session.
Better to take downtime before doing this activity.

Comments (0)

Please to add comments

No comments yet. Be the first to comment!