To enable encryption, either the ENCRYPTION or ENCRYPTION_PASSWORD parameter, or both, must be specified. If only the ENCRYPTION_PASSWORD parameter is specified, then the ENCRYPTION parameter defaults to ALL. If neither ENCRYPTION nor ENCRYPTION_PASSWORD is specified, then ENCRYPTION defaults to NONE. Data pump encryption is specified by the encryption parameter, the algorithm of the encryption and the mode of the encryption
Demo1:-
We are passing the password in export parameter.
expdp scott/tiger tables=oracledbwr directory=TEST_DIR dumpfile=oracledbwr.dmp logfile=oracledbwr.log encryption=all encryption_pasword=oracle123
Export: Release 18.0.0.0.0 - Production on Thu Aug 23 23:23:15 2018
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Starting "SCOTT"."SYS_EXPORT_TABLE_01": scott/******** tables=oracledbwr directory=TEST_DIR dumpfile=oracledbwr.dmp logfile=oracledbwr.log encryption=all encryption_password=********
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Processing object type TABLE_EXPORT/TABLE/TABLE
. . exported "SCOTT"."ORACLEDBWR" 17.30 KB 1792 rows
Master table "SCOTT"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SCOTT.SYS_EXPORT_TABLE_01 is:
/u01/app/oracle/datapump/oracledbwr.dmp
Job "SCOTT"."SYS_EXPORT_TABLE_01" successfully completed at Thu Aug 23 23:23:43 2018 elapsed 0 00:00:16
Passing wrong password while impdp
impdp scott/tiger tables=oracledbwr directory=TEST_DIR dumpfile=oracledbwr.dmp logfile=oracledbwr.log remap_table=scott.oracledbwr:oracledbwr1 encryption_password=oracle561
Import: Release 18.0.0.0.0 - Production on Thu Aug 23 23:24:20 2018
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
ORA-39002: invalid operation
ORA-39176: Encryption password is incorrect.
Passing Correct password while impdp
impdp scott/tiger tables=oracledbwr directory=TEST_DIR dumpfile=oracledbwr.dmp logfile=oracledbwr.log remap_table=scott.oracledbwr:oracledbwr1 encryption_password=oracle123
Import: Release 18.0.0.0.0 - Production on Thu Aug 23 23:24:31 2018
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Master table "SCOTT"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "SCOTT"."SYS_IMPORT_TABLE_01": scott/******** tables=oracledbwr directory=TEST_DIR dumpfile=oracledbwr.dmp logfile=oracledbwr.log remap_table=scott.oracledbwr:oracledbwr1 encryption_password=********
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "SCOTT"."ORACLEDBWR1" 17.30 KB 1792 rows
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Job "SCOTT"."SYS_IMPORT_TABLE_01" successfully completed at Thu Aug 23 23:24:55 2018 elapsed 0 00:00:23
Catch Me On:- Hariprasath Rajaram
Telegram:https://t.me/joinchat/I_f4DhGF_Zifr9YZvvMkRg
LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter: https://twitter.com/hariprasathdba
