Encryption mode: Password Encryption algorithm: AES128 impdp directory=DATA_PUMP_DIR dumpfile=encrypted.dmp decrypt_password=wrong_pass If password is wrong, ORA-39189 appears immediately. 5. Solutions 5.1 Password-based encryption (most common) Problem: Missing or wrong DECRYPTION_PASSWORD .
impdp user/pass DIRECTORY=dp_dir DUMPFILE=encrypted.dmp \ DECRYPTION_PASSWORD=correct_password Problem: Wallet not open or missing. ora-39189 unable to decrypt dump file set
ADMINISTER KEY MANAGEMENT SHOW ENCRYPTION KEYS; ora-39189 unable to decrypt dump file set