Syntax and Description
ENCRYPTION_PWD_PROMPT=[YES | NO]
ENCRYPTION_PWD_PROMPT=YES on the command line to instruct Data Pump to prompt you for the encryption password, rather than you entering it on the command line with the
ENCRYPTION_PASSWORD parameter. The advantage to doing this is that the encryption password is not echoed to the screen when it is entered at the prompt. Whereas, when it is entered on the command line using the
ENCRYPTION_PASSWORD parameter, it appears in plain text.
The encryption password that you enter at the prompt is subject to the same criteria described for the
If you specify an encryption password on the export operation, you must also supply it on the import operation.
Concurrent use of the
ENCRYPTION_PASSWORD parameters is prohibited.
The following example shows Data Pump first prompting for the user password and then for the encryption password.
> impdp hr DIRECTORY=dpump_dir1 DUMPFILE=hr.dmp ENCRYPTION_PWD_PROMPT=YES . . . Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved. Password: Connected to: Oracle Database 12c Enterprise Edition Release 22.214.171.124.0 - 64bit Production With the Partitioning, Advanced Analytics and Real Application Testing options Encryption Password: Master table "HR"."SYS_IMPORT_FULL_01" successfully loaded/unloaded Starting "HR"."SYS_IMPORT_FULL_01": hr/******** directory=dpump_dir1 dumpfile=hr.dmp encryption_pwd_prompt=Y . . .