Oracle 11g Encryption

All we need is an easy explanation of the problem, so here it is.

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.

How to solve :

I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.

Method 1

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.

Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply