<<Back to Oracle DATAPUMP Main Page
ORA-39173: Encrypted data has been stored unencrypted in dump file set
$ expdp test@PDB01 parfile=exp.par
Export: Release 12.2.0.1.0 - Production on Wed Nov 28 11:30:14 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
Starting "TEST"."SYS_EXPORT_TABLESPACE_01": test/********@PDB01 parfile=exp.par
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
. . exported "TEST"."EXP_EDITION_TEST" 5.648 KB 14 rows
. . exported "TEST"."EMP" 5.531 KB 5 rows
. . exported "TEST"."EMP1" 5.476 KB 1 rows
. . exported "TEST"."TEST" 5.476 KB 1 rows
. . exported "TEST"."EMP_EDITION2" 5.484 KB 1 rows
. . exported "TEST_EXP"."TEST" 5.070 KB 3 rows
. . exported "TEST"."ENC_TEST1" 6.367 KB 0 rows
. . exported "TEST"."ENC_TEST2" 6.367 KB 0 rows
. . exported "TEST"."ENC_TEST3" 6.789 KB 0 rows
. . exported "TEST"."ENC_TEST4" 6.367 KB 0 rows
ORA-39173: Encrypted data has been stored unencrypted in dump file set.
Master table "TEST"."SYS_EXPORT_TABLESPACE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for TEST.SYS_EXPORT_TABLESPACE_01 is:
/u01/dbatst1/stage/EXP.DMP
Job "TEST"."SYS_EXPORT_TABLESPACE_01" successfully completed at Wed Nov 28 11:31:49 2018 elapsed 0 00:01:16
Cause: No encryption password was specified while exporting the encrypted data. This is just warning that the dumpfile is not secure and the encrypted data can be compromised from this dumpfile.
Solution: To protect the encrypted data while exporting the database either specify ENCRYPTION_MODE or ENCRYPTION_PASSWORD parameter to secure the export dumpfile. You need later this password or wallet to import the data from this export dump
$ cat exp.par
DIRECTORY=EXP
DUMPFILE=EXP.DMP
LOGFILE=EXP.LOG
TABLESPACES=TEST
REUSE_DUMPFILES=Y
ENCRYPTION_PASSWORD=mysecret
FLASHBACK_TIME=SYSTIMESTAMP
Related Articles
How to Perform Encrypted Database Export
Comments
Post a Comment