Oracle Transparent Data encryption--table space encryption ____oracle

TDE from 11g to support the entire table space encryption, all stored in the table space of the image is automatically encrypted, do not need to further the table below the partition encryption.
Table space encryption does not support encryption of bfile columns

Oracle's column encryption is available from 10GR2 and table space encryption is started from 11GR1

Table Space Encryption algorithm

3des168,aes128,aes192,aes256, default is AES128

Encrypted decryption diagram

For example: And column encryption is similar, but also in the Sqlnet.ora file to add encryption_wallet_location to specify WALLET position in the previous steps and column encryption system to create WALLET directory, specify WALLET location mkdir-p/opt/ Oracle/admin/skydb/wallet Modify Sqlnet.ora Add the following enryption_wallet_location = (source= (method=file) METHOD_DATA= ( Directory=/opt/oracle/admin/skydb/wallet)) The database creates the wallet and sets the access password alter system set encryption key authenticated by "
123456 ";

Open WALLET ALTER SYSTEM SET encryption WALLET open identified by "123456";
Creating an encrypted tablespace create tablespace securespace datafile '/home/oracle/oracle3/product/11.1.0/db_1/secure01.dbf ' SIZE 150M

Encryption DEFAULT STORAGE (ENCRYPT);
CREATE table in encrypted tablespace customer_payment_info (first_name VARCHAR2 (), last_name VARCHAR2 (), Order_number number (5),


Credit_card_number VARCHAR2 (), Active_card VARCHAR2 (3)) tablespace securespace;
Insert data into Cust_payment_info VALUES (' Jon ', ' Oldfield ', 10001, ' 5446959708812985 ', ' YES '); 
INSERT into Cust_payment_info VALUES (' Chris ', ' White ', 10002, ' 5122358046082560 ', ' YES '); INSERT into Cust_payment_info VALUES (' Alan ', ' Squire ', 10003, ' 5595968943757920 ', ' YES ');
INSERT into Cust_payment_info VALUES (' Mike ', ' Anderson ', 10004, ' 4929889576357400 ', ' YES ');
INSERT into Cust_payment_info VALUES (' Annie ', ' Schmidt ', 10005, ' 4556988708236902 ', ' YES ');
INSERT into Cust_payment_info VALUES (' Elliott ', ' Meyer ', 10006, ' 374366599711820 ', ' YES ');
INSERT into Cust_payment_info VALUES (' Celine ', ' Smith ', 10007, ' 4716898533036 ', ' YES ');
INSERT into Cust_payment_info VALUES (' Steve ', ' Haslam ', 10008, ' 340975900376858 ', ' YES ');


INSERT into Cust_payment_info VALUES (' Albert ', ' Einstein ', 10009, ' 310654305412389 ', ' YES '); You can view those tablespace encryption through the V$encrypted_tablespaces view, as well as the cryptographic algorithm-related data dictionary all_encrypted_columns dba_encrypted_columns user_encrypted_ COLUMNS V$wallet v$encrypted_tablespaces V$encryption_wallet

Reference: oracle11g TDE