Encrypting tablespace

It is not possible to encrypt an existing tablespace using TDE tablespace encryption. In this recipe, you'll create a new encrypted tablespace.

Getting ready

It is assumed that a keystore is opened and a master key is created.

How to do it...

1. Connect to the database as a user who has a create tablespace privilege (for example, zoran):

   $ sqlplus zoran
   

2. Create encrypted tablespace (for example, TEST_ENC) using AES192 encryption algorithm:

   SQL> CREATE TABLESPACE TEST_ENC
   DATAFILE '/u01/app/oracle/oradata/ORA12CR1/datafile/testenc01.dbf'
   SIZE 20M
   ENCRYPTION USING 'AES192'
   DEFAULT STORAGE (ENCRYPT);
   

   

   Figure 22 - Encrypting tablespace

How it works...

In step 2, you create an encrypted tablespace TEST_ENC. To find information about encrypted tablespaces, you can query the V$ENCRYPTED_TABLESPACES view.

Figure 23 - Finding information about encrypted tablespace

There's more...

You can import existing tables into encrypted tablespace using Oracle Data Pump. Another option is to use SQL...