ENCRYPTION

How to encrypt a table using dbm_redef with zero down time

We can encrypt a table using simple alter table command, However alter table command on big tables takes time and during this process, transaction will be blocked on that table. So best solution to av...

How to create encrypted tablespace in PDB( oracle 12c)

For creating an encrypted tablespace in a PLUGGABLE DATABASE ( PDB) for multitenant oracle 12c setup, we need to do a few additional steps. DEMO: In the below DEMO, we will create a encrypted tablespa...

ENCRYPTION in expdp impdp

We can enable password based encryption for expdp dumps, by using different encryption related parameters in expdp/impdp command. ENCRYPTION RELATED PARAMETERS: ENCRYPTION Encrypt part or all of a dum...

ORA-39174: Encryption password must be supplied

PROBLEM: While importing a dump, getting below error: Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production With the Partitioning, OLAP, Advanced Analytics a...