Tagged: quiescing oracle database

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...