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
  • So in that case (11g) the tablespace is offlined and the datafiles are individually encrypted? It has to be possible as DataGuard doesn't automatically encrypt the standby in 11g so it's done manually.
    – Franco
    Commented May 24, 2021 at 22:41
  • 1
    @Franco Yes, it is possible, that is functionality that was backported to 11.2.0.4 and 12.1.0.2. docs.oracle.com/en/database/oracle/oracle-database/21/asoag/… Also, for Data Guard: oracle.com/technetwork/database/availability/… I used these steps myself as well as part of on-premise -> cloud migrations. Commented May 24, 2021 at 22:54
  • Excellent. Many thanks.
    – Franco
    Commented May 25, 2021 at 12:34

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.