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
No comments:
Post a Comment