Sunday , October 22 2017
Home / Oracle DBA / TABLESPACE ENCRYPTION

TABLESPACE ENCRYPTION

TABLESPACE ENCRYPTION

Oracle Database 10g introduced Transparent Data Encryption (TDE), which enabled you to encrypt columns in a table. The feature is called “transparent” because the database takes care of all the encryption and decryption details. In Oracle Database 11g, you can also encrypt an entire table space. In fact, table space encryption helps you get around some of the restrictions imposed on encrypting a column in a table through the TDE feature. For example, you can get around the restriction that makes it impossible for you to encrypt a column that’s part of a foreign key or that’s used in another constraint, by using table space encryption.
Restrictions on Table space Encryption
You must be aware of the following restrictions on encrypting table spaces. You
  1. Can’t encrypt a temporary or an undo table space.
  2. Can’t change the security key of an encrypted table space.
  3. Can’t encrypt an external table.
As with TDE, you need to create an Oracle Wallet to implement table space encryption. Therefore,let’s first create an Oracle Wallet before exploring how to encrypt a table space.
Read More:
ARCHIVELOG FILES
MULTIPLEXING REDOLOG FILES
STEPS to create database manually

Comments

comments

Check Also

Moving a database from Normal File System to ASM storage

Default storage for oracle database is File System, where database files resides on local storage. …

Leave a Reply

Your email address will not be published. Required fields are marked *