ENCRYPTION WALLET IN ORACLE

Set the below config in sqlnet.ora

ENCRYPTION_WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=C:\app\Administrator\admin\orcl\wallet\))


set wallet password.......

11:37:51 Scott@std>>ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY "hello";


11:42:34 SCOTT@std>>CREATE TABLE tde_test (    === creating the table with encrypt option.
11:42:36   2    id    NUMBER(10),
11:42:36   3    data  VARCHAR2(50) ENCRYPT
11:42:36   4  );

Table created.

11:42:39 SCOTT@std>>desc tde_test
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------

 ID                                                 NUMBER(10)
 DATA                                               VARCHAR2(50) ENCRYPT   ==> Here it showing encrypt config for that column
11:42:44 SCOTT@std>>SELECT * FROM dba_encrypted_columns; ==> Same is showing in data dict also.

OWNER                          TABLE_NAME
============================== ==============================
COLUMN_NAME                    ENCRYPTION_ALG                SAL INTEGRITY_AL
============================== ============================= === ============
SCOTT                          TDE_TEST
DATA                           AES 192 bits key              YES SHA-1




Disabling the encrypt.....
ALTER SYSTEM SET ENCRYPTION WALLET CLOSE;