0

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.

1 Answer 1

0

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.

3

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.