Thanks for the question, oracle.
Asked: May 10, 2017 - 7:08 am UTC
Last updated: May 11, 2017 - 3:10 am UTC
Version: 11.2.0
Viewed 1000+ times
You Asked
I have export schema of production (CPG_PROD) now i want to restore on development server where i have alredy CPG_PROD schema.
Now i want to restore production CPG_PROD On development but same name is already there so
How can i import the production schema on development because same name schema is alredy there.
As i know remap_schema=importschema:newschema but will it rename the existing cpg_prod schema on development or this parameter not touch on existing schema on dev Pls suggest.
Thanks
and Connor said...
If you want to *overwrite* the existing schema, simply do:
drop user CPG_PROD cascade
on the target system before you run the impdp.
If you want to import into a*new* schema, then using REMAP_SCHEMA as you suggested will leave the existing schema untouched.
Is this answer out of date? If it is, please let us know via a Comment