Data Pump Encryption in Oracle

[oracle@india ~]$ expdp directory=DATA_PUMP_DIR dumpfile=hameed.dmp logfile=hameed.log schemas=hameed encryption=all encryption_password=oracle encryption_algorithm=AES256 ENCRYPTION_MODE=password

Export: Release 11.2.0.4.0 - Production on Sun May 14 13:25:54 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Username: / as sysdba

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYS"."SYS_EXPORT_SCHEMA_01": /******** AS SYSDBA directory=DATA_PUMP_DIR dumpfile=hameed.dmp logfile=hameed.log schemas=hameed encryption=all encryption_password=******** encryption_algorithm=AES256 ENCRYPTION_MODE=password
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
. . exported "HAMEED"."INFO" 5.835 KB 1 rows
Master table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is:
/u01/app/oracle/admin/Stage/dpdump/hameed.dmp
Job "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at Sun May 14 13:27:32 2017 elapsed 0 00:01:13

[oracle@india ~]$ impdp directory=DATA_PUMP_DIR dumpfile= hameed.dmp logfile=hameedimp.log remap_schema=hameed:abdul

Import: Release 11.2.0.4.0 - Production on Sun May 14 13:33:31 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Username: / as sysdba

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39174: Encryption password must be supplied.

[oracle@india ~]$ impdp directory=DATA_PUMP_DIR dumpfile= hameed.dmp logfile=hameedimp.log remap_schema=hameed:abdul encryption_password=oracl

Import: Release 11.2.0.4.0 - Production on Sun May 14 13:36:17 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Username: / as sysdba

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39176: Encryption password is incorrect.

[oracle@india ~]$ impdp directory=DATA_PUMP_DIR dumpfile= hameed.dmp logfile=hameedimp.log remap_schema=hameed:abdul encryption_password=oracle

Import: Release 11.2.0.4.0 - Production on Sun May 14 13:35:42 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Username: / as sysdba

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_FULL_01": /******** AS SYSDBA directory=DATA_PUMP_DIR dumpfile= logfile=hameedimp.log remap_schema=hameed:abdul encryption_password=********
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"ABDUL" already exists
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "ABDUL"."INFO" 5.835 KB 1 rows
Job "SYS"."SYS_IMPORT_FULL_01" completed with 1 error(s) at Sun May 14 13:35:53 2017 elapsed 0 00:00:07

MOHAMMED ABDUL HAMEED | Welcome - Geeksss