Search This Blog

Total Pageviews

Saturday 14 January 2012

ORA-39173: Encrypted data has been stored unencrypted in dump file set.

 



in Datapump if you are getting this error
ORA-39173: Encrypted data has been stored unencrypted in dump file set.




ORA-39173: Encrypted data has been stored unencrypted in dump file set.
Master table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is:
/home/oracle/Oracle_Datapump/orcl.datapump..dmp
Job "SYS"."SYS_EXPORT_SCHEMA_01" completed with 1 error(s) at 16:02:28


Then check folloing pl

 

select * from v$option where parameter like 'Transparent Data Encryption%';

PARAMETER VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
Transparent Data Encryption TRUE

 

 encryption_password=xxx    provide some password 

 

 expdp "'/ as sysdba'" directory=anuj_datapump  SCHEMAS=scott  EXCLUDE=STATISTICS parallel=4 encryption_password=vihaan

 

this time no error

 

Master table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is:
/home/oracle/Oracle_Datapump/orcl.datapump.14012012.dmp

Job "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at 18:34:30

 



Oracle DBA

anuj blog Archive