<<Back to Oracle DATAPUMP Main Page
$ expdp system@PDB01 parfile=exp_full_pdb01.par
Export: Release 12.2.0.1.0 - Production on Fri Oct 12 12:06:23 2018
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Password:
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
ORA-39002: invalid operation
ORA-39188: unable to encrypt dump file set
ORA-28365: wallet is not open
Cause:
Data Pump could not create an encrypted dump file set. The most common reason for this message is that you are trying to create a dump file set that can be transparently decrypted, and the database external security device is not open.
As it is clear from the addition message as well
ORA-28365: wallet is not open
Solution:
If the external security device is not open, then open it. If the external security device is not configured (which is in my case ), then the only type of encrypted dump file set that you can create is a password-based dump file set. To create password based encrypted dump files use ENCRYPTION_PASSWORD=password together with ENCRYPTION parameter
Example parfile
$ cat exp_full_pdb01.par
directory=dump
dumpfile=EXP_PDB01_FULL%U.dmp
logfile=EXP_PDB01_FULL.log
schemas=TEST
ENCRYPTION=data_only
ENCRYPTION_PASSWORD=testencryption
Comments
Post a Comment