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.
Encrypting an existing tablespace became possible in 12.2.
You cannot encrypt an existing tablespace.
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 🙂