-
Book Overview & Buying
-
Table Of Contents
Oracle 11g Anti-hacker's Cookbook
By :
While TDE Column encryption is available from 10g R2, TDE tablespace encryption is an exclusive 11g feature and was introduced in Oracle R1 (11.1.0.5). Using this option ensures that all tables and indexes contained within a tablespace will be encrypted transparently.
In this recipe, we will create an encrypted tablespace called ENCRYPTED_TBS using TDE.
All steps will be performed using HACKDB database.
For this chapter we will reuse the encryption wallet defined in the previous recipe Using column Transparent Data Encryption:
To create encrypted objects using TDE, the encryption wallet must have the status as OPEN. To check the availability of the encryption wallet, issue the following statement:
SQL> select wrl_parameter,status from v$encryption_wallet; WRL_PARAMETER - STATUS ------------------------- -------------------------- /security/wallets/tde OPEN
The wallet is open and can be used for encryption. Create...
Change the font size
Change margin width
Change background colour