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
DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.

Check Also

Oracle 10g to 11g Enhancements (Difference between Oracle 10g and 11g)

Difference between Oracle 10g and 11g 1- Enhanced Automatic Memory Management System Oracle 9i automated …

Leave a Reply

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

DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.
close-link
GET OUR LATEST CONTENT IN YOUR INBOX

SUBSCRIBE 
Your information will never be shared
close-link
Enquiry
Submit
close-link
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.
Subscribe