Oracle Data Pump Encryption

Onur ARDAHANLI

2 years ago

We use ENCRYPTION as Encryption parameter in Oracle Data Pump.

We can use the ENCRYPTION parameter with the values ALL, DATA_ONLY, METADATA_ONLY and ENCRYPTED_COLUMNS_ONLY.

-bash-3.2$ expdp "'/ as sysdba'" directory=dump_dir schemas=scott dumpfile=scott%U.dmp logfile=scott.log 
reuse_dumpfiles=y parallel=2 compression=all encryption=all

1 2	-bash-3.2$ expdp "'/ as sysdba'" directory=dump_dir schemas=scott dumpfile=scott%U.dmp logfile=scott.log reuse_dumpfiles=y parallel=2 compression=all encryption=all