Remap multiple schemas in IMPDP in the import process of Oracle

We exported multiple schemas in one dump file. We want to import the various schemas in the IMPDP datapump.

Export multiple schemas in one dump file:

expdp  sys@ORCL as sysdba  DIRECTORY=exp_schema  DUMPFILE=exp_all_schema.dmp  LOGFILE=exp_all_schema.log SCHEMAS=HR,SCOTT

Import multiple schemas from the dump file:

Use remap to import multiple schemas with a new name like HR to HR_NEW example remap_schema=HR:HR_NEW

impdp sys@orcl as sysdba DIRECTORY=exp_schema  DUMPFILE=exp_all_schema.dmp  LOGFILE=impo_all_schema.log remap_schemas=HR:HR_NEW,SCOTT:SCOTT_NEW

The directory parameter is used to configure before use in the data pump as follows:

sqlplus / as sysdba
CREATE DIRECTORY exp_schema AS 'E:\DataPump\';
GRANT read,write ON DIRECTORY exp_schema TO user;