It is not possible to encrypt an existing tablespace using TDE tablespace encryption. In this recipe, you'll create a new encrypted tablespace.
Connect to the database as a user who has a create tablespace privilege (for example,
zoran
):$ sqlplus zoran
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);
In step 2, you create an encrypted tablespace TEST_ENC
. To find information about encrypted tablespaces, you can query the V$ENCRYPTED_TABLESPACES
view.