Skip to Main Content
  • Questions
  • Import Production Dump to new schema


Question and Answer

Connor McDonald

Thanks for the question, Jeyaram.

Asked: December 18, 2019 - 4:48 am UTC

Answered by: Connor McDonald - Last updated: December 18, 2019 - 6:13 am UTC

Category: Database Administration - Version: 19.2.2

Viewed 100+ times

You Asked


We have a live project which has only 1 schema. We are upgrading some features and so we are going to release it as version 2.0 .

My question is that the production dump which is only one schema has to be to imported to 4 different schema of different names . Is it possible if so how to achieve it, if not what is the alternative approach.

and we said...

Yes, that is easy. Run 4 imports, each one with REMAP_SCHEMA, ie

impdp .... remap_schema=orig_schema:new_schema1

impdp .... remap_schema=orig_schema:new_schema2

impdp .... remap_schema=orig_schema:new_schema3

impdp .... remap_schema=orig_schema:new_schema4

More to Explore


All of the database utilities are explained in the Utilities guide.