Search This Blog

Thursday, May 12, 2011

Tablespace Encryption

Transparent Data Encryption (TDE) and the use of a component known as the Oracle Wallet. Oracle 10.2.4 +


CREATE TABLESPACE encrypted_ts
DATAFILE 'C:\ORACLE\ORADATA\SECURE\encrypted_ts01.dbf' SIZE 128K
LOGGING
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO
ENCRYPTION USING 'AES192'
DEFAULT STORAGE(ENCRYPT);

The link shows you how you are able to create a wallet.
http://mikegeorgiou.blogspot.com/2011/05/column-ecryption-in-oracle-10g.html