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