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 dump file.
Valid keyword values are: ALL, DATA_ONLY, ENCRYPTED_COLUMNS_ONLY, METADATA_ONLY and NONE.

ENCRYPTION_ALGORITHM
Specify how encryption should be done.
Valid keyword values are: [AES128], AES192 and AES256.

ENCRYPTION_MODE
Method of generating encryption key.
Valid keyword values are: DUAL, PASSWORD and [TRANSPARENT].

ENCRYPTION_PASSWORD
Password key for creating encrypted data within a dump file.

ENCRYPTION_PWD_PROMPT ——– >>>>>>> INTRODUCED IN ORACLE 12C
Specifies whether to prompt for the encryption password [NO].
Terminal echo will be suppressed while standard input is read.

ENCRYPTION_PASSWORD:

To encrypt any dumpfile, provide password to ENCRYPTION_PASSWORD in parfile.

Export log

ENCRYPTION_PWD_PROMPT

With this parameter, No need to write the password in parfile or expdp command , we can pass the password, when it asks for input.

ENCRYPTION PARAMETER DURING IMPDP

If the export dump is generated using an encryption password, then while importing the dump, we need to pass the same password.

If you try to import without encryption password, it will throw an error as ORA-39174: Encryption password must be supplied.