We can use ENCRYPTION_MODE parameter with EXPDP, it will provide us additional encryption with backup.
Note:
1. Feature is used with Enterprise edition of Oracle.
2. Compatibility for DUAL and transparent use is minimum 11.0.0 compatibility.
ENCRYPTION_MODE has following option
ENCRYPTION_MODE = [DUAL | PASSWORD | TRANSPARENT]
PASSWORD: It use excryption_password during export and import.
TRANSPARENT: It use wallet, With open wallet you can export or import.
DUAL: Create a dump file that either import with password or Oracle wallet which ever specified during export(DEFAULT use both PASSWORD or TRANSPARENT)
We can use ENCRYPTION_MODE parameter with EXPDP, it will provide us additional encryption with backup.
Note: 1. Feature is used with Enterprise edition of Oracle. 2. Compatibility for DUAL and transparent use is minimum 11.0.0 compatibility.
ENCRYPTION_MODE has following option
ENCRYPTION_MODE = [DUAL | PASSWORD | TRANSPARENT]
PASSWORD: It use excryption_password during export and import. TRANSPARENT: It use wallet, With open wallet you can export or import. DUAL: Create a dump file that either import with password or Oracle wallet which ever specified during export(DEFAULT use both PASSWORD or TRANSPARENT)
Example of EXPDP and IMPDP
expdp username/password directory=dbbackup dumpfile=test.dmp logfile=test.log encryption=all encryption_mode=password encryption_password=test tables='test'; impdp username/password directory=dbbackup dumpfile=test.dmp logfile=test.log encryption_password=test;