Data pump encryption required the ENCRYPTION_PASSWORD parameter to be entered on the command line, making password snooping relatively easy.
In Oracle 12c, the ENCRYPTION_PWD_PROMPT parameter enables encryption without requiring the password to be entered as a command line parameter. Instead, the user is prompted for the password at runtime, with their response not echoed to the screen.
ENCRYPTION_PWD_PROMPT=[YES | NO]
In early version
expdp scott/tiger tables=emp directory=TEST_DIR dumpfile=emp.dmp logfile=emp.log encryption_password=oracle123
Demo:-
[oracle@prod101:~ orcl101] expdp scott/tiger tables=emp directory=TEST_DIR dumpfile=emp2.dmp logfile=emp2.log ENCRYPTION_PWD_PROMPT=yes Export: Release 18.0.0.0.0 - Production on Fri Aug 24 02:06:42 2018 Version 18.3.0.0.0 Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Encryption Password: Starting "SCOTT"."SYS_EXPORT_TABLE_01": scott/******** tables=emp directory=TEST_DIR dumpfile=emp2.dmp logfile=emp2.log ENCRYPTION_PWD_PROMPT=yes Processing object type TABLE_EXPORT/TABLE/TABLE_DATA Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER Processing object type TABLE_EXPORT/TABLE/TABLE . . exported "SCOTT"."EMP" 0 KB 0 rows Master table "SCOTT"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded ****************************************************************************** Dump file set for SCOTT.SYS_EXPORT_TABLE_01 is: /u01/app/oracle/datapump/emp2.dmp Job "SCOTT"."SYS_EXPORT_TABLE_01" successfully completed at Fri Aug 24 02:07:01 2018 elapsed 0 00:00:19
Catch Me On:- Hariprasath Rajaram
Telegram:https://t.me/joinchat/I_f4DhGF_Zifr9YZvvMkRg
LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter: https://twitter.com/hariprasathdba
