When exporting and importing tables from a source database to a target database using Oracle Data Pump, make sure to use the appropriate REMAP parameters in the impdp command for schemas, table, and tablespace. If ENCRYPTION is used during the expdp operation, ensure that you securely retain the encryption password used during the export. The same password is required during the import operation otherwise, you will not be able to import the encrypted dump file. #Use below command to table table export using data pump expdp Source: Schema : ENC Table : ENC_TAB Tablespac : ENC_TEST Target: Schema : ENCMOCK Table : ENC_TAB_MOCK Tablespace : ENC_MOCK1 |
#Use below command to table table export using data pump expdp $expdp ENC/Oracle#1234 DIRECTORY=TMP_ENC_DUMP TABLES=ENC.ENC_TAB DUMPFILE=ENC_TAB.dmp LOGFILE=exp_ENC_TAB.log ENCRYPTION=ALL ENCRYPTION_ALGORITHM=AES256 ENCRYPTION_PASSWORD=test1234 Export: Release 19.0.0.0.0 - Production on Fri Aug 21 17:31:01 2026 Version 19.30.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Starting "ENC"."SYS_EXPORT_TABLE_01": enc/******** DIRECTORY=TMP_ENC_DUMP TABLES=ENC.ENC_TAB DUMPFILE=ENC_TAB.dmp LOGFILE=exp_ENC_TAB.log ENCRYPTION=ALL ENCRYPTION_ALGORITHM=AES256 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 "ENC"."ENC_TAB" 5.578 KB 5 rows Master table "ENC"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded ****************************************************************************** Dump file set for ENC.SYS_EXPORT_TABLE_01 is: /Temporary_EXPORT/TMP_ENC_DUMP/ENC_TAB.dmp Job "ENC"."SYS_EXPORT_TABLE_01" successfully completed at Fri Aug 21 17:33:49 2026 elapsed 0 00:01:26 #Use below command to table table export using data pump impdp $impdp ENCMOCK/Oracle#1234 DIRECTORY=TMP_ENC_DUMP DUMPFILE=ENC_TAB.dmp LOGFILE=imp_ENC_TAB_with_encry_pwd2.log REMAP_SCHEMA=ENC:ENCMOCK REMAP_TABLE=ENC_TAB:ENC_TAB_MOCK REMAP_TABLESPACE=ENC_TEST:ENC_MOCK1 ENCRYPTION_PASSWORD=test1234 cluster=N Import: Release 19.0.0.0.0 - Production on Fri Aug 21 19:46:28 2026 Version 19.30.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Master table "ENCMOCK"."SYS_IMPORT_FULL_02" successfully loaded/unloaded Starting "ENCMOCK"."SYS_IMPORT_FULL_02": ENCMOCK/******** DIRECTORY=TMP_ENC_DUMP DUMPFILE=ENC_TAB.dmp LOGFILE=imp_ENC_TAB_with_encry_pwd2.log REMAP_SCHEMA=ENC:ENCMOCK REMAP_TABLE=ENC_TAB:ENC_TAB_MOCK REMAP_TABLESPACE=ENC_TEST:ENC_MOCK1 ENCRYPTION_PASSWORD=******** cluster=N Processing object type TABLE_EXPORT/TABLE/TABLE Processing object type TABLE_EXPORT/TABLE/TABLE_DATA . . imported "ENCMOCK"."ENC_TAB_MOCK" 5.578 KB 5 rows Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER Job "ENCMOCK"."SYS_IMPORT_FULL_02" successfully completed at Fri Aug 21 19:47:50 2026 elapsed 0 00:00:47 |
Thanks for reading this post ! Please comment if you like this post ! Click on FOLLOW to get next blog updates !
