Chapter 8. Transparent Data Encryption

In this chapter, we will cover the following tasks:

  • Configuring a keystore location in sqlnet.ora
  • Creating and opening the keystore
  • Setting a master encryption key in a software keystore
  • Column encryption - adding a new encrypted column to a table
  • Column encryption - creating a new table that has encrypted column(s)
  • Using salt and MAC
  • Column encryption - encrypting the existing column
  • Autologin keystore
  • Encrypting tablespace
  • Rekeying
  • Backup and recovery


Encryption is a very important security mechanism used to enforce confidentiality of data. There are two types of encryption that can be used in the Oracle Database. The first type is application-based encryption, which is implemented using the DBMS_CRYPTO ...

Get Oracle Database 12c Security Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.