For creating an encrypted tablespace in a PLUGGABLE DATABASE ( PDB) for multitenant oracle 12c setup, we need to do a few additional steps.


In the below DEMO, we will create a encrypted tablespace under a pluggable database SDCP1

1. Update sqlnet.ora file with ENCRYPTION_WALLET_LOCATION

2. Set encryption key at container DB:

3. Take the backup of the created keystore.

Always create a backup of the keystore , before doing any changes.

4. Now set the keystore in the pluggable database(PDB).

In our case, SDC1 is a pluggable db.

5. Create the encrypted tablespace:

We have successfully created an encrypted tablespace in the PDB.