ORACLE 12C: Expdp encryption password

Starting from release 12C there is a new option to pass in silent mode
encryption password .
The ENCRYPTION_PWD_PROMPT parameter enables encryption without
requiring the password to be entered as a command line parameter.
The user is prompted for the password during export utility.
expdp … ENCRYPTION_PWD_PROMPT=Y
Password: <user is asked for encryption password>
In previous release encryption password was explicit passed to expdp utility
using parameter ENCRYPTION_PASSWORD. So could be visible via
operation system command “ps –ef …” .
Features:
 new parameter ENCRPTION_PWD_PROMPT as default set to N
 if the parameter is set to Y then user is asked for encryption password
during export
 old 11g ENCRYPTION_PASSWORD and
ENCRYPTION_PWD_PROMPT=Y can’t be used in the same time and
generate an error

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *