Thanks for the question, Jeyaram.
Asked: December 18, 2019 - 4:48 am UTC
Last updated: December 18, 2019 - 6:13 am UTC
Version: 19.2.2
Viewed 1000+ times
You Asked
Hi,
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 Connor 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
Is this answer out of date? If it is, please let us know via a Comment