In Oracle 10g itself Transparent Data Encryption (TDE) was introduced. But the downside of that feature was that we could only perform the encryption individually at the table column level.
Now in Oracle 11g, we can enable encryption at the tablespace level and that will then cascade down to every table which resides in that particular tablespace.
Let’s now see the steps involved.
We need to specify the encryption wallet location in the sqlnet.ora file as shoewn below.
ENCRYPTION_WALLET_LOCATION=
(SOURCE=(METHOD=FILE)(METHOD_DATA=
(DIRECTORY=/u01/app/oracle/admin/leven202/wallet)))
Next provide an encryption key for the wallet. Think of it as a password which will be required to open the wallet.
SQL> ALTER SYSTEM SET ENCRYPTION KEY AUTHENTICATED BY “gavin”;
System altered.
We will see that a file ‘ewallet.p12′ has been created in the location which we specified for the wallet in the sqlnet.ora.
SQL> !ls /u01/app/oracle/admin/leven202/wallet
ewallet.p12
Note – this will also automatically open the wallet as well. If we try and open the
Continue reading 11g Tablespace Encryption
Popular Posts