Online Tutorials & Training Materials | STechies.com
Register Login

Importing Multiple Schema to Another User using IMPDP

Sugandh || 01 Oct 2015 2:28 pm || 1

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 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