Oracle 11g – Data Encryption Techniques

linuxoracleoracle-11g-r2transparent-data-encryption

Can somebody please tell me how to encrypt an existing tablespace in 11g? The wallet has been setup and the sqlnet.ora points to it.

SQL> select STATUS  FROM V$ENCRYPTION_WALLET;

STATUS
------------------
OPEN

I alter the tablespace offline …

alter tablespace USERS offline normal;

But I can only find the 12n and above command for the next part:

ALTER TABLESPACE users ENCRYPTION OFFLINE ENCRYPT;

Many thanks in advance for the 11g command.

Best Answer

Encrypting an existing tablespace became possible in 12.2.

11g documentation:

Creating an Encrypted Tablespace

You cannot encrypt an existing tablespace.

12.1 documentation:

About Creating Encrypted Tablespaces

You cannot change an existing tablespace to make it encrypted.

Related Question