Importing Multiple Schema to Another User using IMPDP

Updated May 18, 2018

Oracle IMPDP remap_schema

Hello Experts,

May I know that How to import multiple schemas to another user using impdp.

I have tried like impdp directory = dtpdir dumpfile=schema.dmp logfile=schema.log remap_schema = 'schema1:user1,schema2:user1

It is working but only latest schema(schema2) is copied to user1 but not schema1.

So Please give me the solution, thanks in advance.

Comments

21 Oct 2016 6:01 pm Guest Helpful Answer

Please use sql query given below in order to import and export multiple schema using impdp:
impdp schemas=schema1,schema2,schema3 directory=DATA_PUMP_DIR dumpfile=schemas120514bkp.dmp logfile=impdpschemas120514.log