dbTalk Databases Forums  

How to restore to a different database name

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss How to restore to a different database name in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Topher
 
Posts: n/a

Default How to restore to a different database name - 05-09-2009 , 02:20 PM






In my development environment, I have two machines, each of which has
a database called "C1" (that's the value we use for the SID and all
those other things that identify the DB).
I need to replicate one of these databases that's on the first machine
onto the second machine, without overwriting what I already am calling
"C1" on the second machine. I want to call the new copy "C2".
I used expdp to create a full database dump of C1 on the first
machine. On the second machine, I used dbca to create C2, and set my
shell's environment variables to refer to that.
I thought that when I used impdp it would import into C2. But no, it
complained about all these problems creating things in C1.
So I tried impdp with the "remap_datafile=C1:C2" option, but that
doesn't seem to fix it.

Can anyone help me here? Thanks.

Reply With Quote
  #2  
Old   
Michael Austin
 
Posts: n/a

Default Re: How to restore to a different database name - 05-09-2009 , 06:34 PM






Topher wrote:
Quote:
In my development environment, I have two machines, each of which has
a database called "C1" (that's the value we use for the SID and all
those other things that identify the DB).
I need to replicate one of these databases that's on the first machine
onto the second machine, without overwriting what I already am calling
"C1" on the second machine. I want to call the new copy "C2".
I used expdp to create a full database dump of C1 on the first
machine. On the second machine, I used dbca to create C2, and set my
shell's environment variables to refer to that.
I thought that when I used impdp it would import into C2. But no, it
complained about all these problems creating things in C1.
So I tried impdp with the "remap_datafile=C1:C2" option, but that
doesn't seem to fix it.

Can anyone help me here? Thanks.
please do not multi-post - use cross-post instead. I you are unfamiliar
with these terms use google to find the difference.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.