RE: Merge datafile to Another DATABASE

That is correct.  Of course you will want to back everything up before you even 
think about starting this process.


Pat



________________________________
From: Prasad [mailto:p4cldba@xxxxxxxxx]
Sent: Friday, January 11, 2008 10:44 AM
To: Elliott, Patrick
Cc: enkhbold@xxxxxxxxxxxx; oracle-l
Subject: Re: Merge datafile to Another DATABASE

Hi Pat,

In order to create the new db I guess it needs the system and sysaux data files 
also . So can you please help my understanding on your reply  that I can pick 
all the system and sysaux tablespace datafiles plus the A_USER_Datafile  and 
build a new db . Please correct me if It is not what you meant.

thanks
-Prasad

On Jan 11, 2008 7:55 AM, Elliott, Patrick < 
patrick.elliott@xxxxxxxxxxxxx<mailto:patrick.elliott@xxxxxxxxxxxxx>> wrote:
The A_USER_Datafile would need to be the only datafile for the tablespace that 
owns it.  You would need to create a new controlfile with just the 
A_USER_Datafile in it in a new database.  Then you would need to do a 
transportable tablespace export using this new database after making the 
tablespace for this datafile readonly.  Then import the transportable 
tablespace export into database B.


Pat



________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx> 
[mailto:oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>] On 
Behalf Of Enkhbold Dashdondog
Sent: Thursday, January 10, 2008 9:18 PM
To: 'oracle-l'
Subject: Merge datafile to Another DATABASE


Hi



I have two different Database server (A, B) with same Database.

If A server database is damaged, but A_USER_ Datafile is fine.

In A Server, export and expdp are not working.



Is possible get A_USER_Datafile and merge to B database?



Enkhbold

___________________________________________________________________________________________________
CONFIDENTIALITY AND PRIVACY NOTICE
Information transmitted by this email is proprietary to Medtronic and is 
intended for use only by the individual or entity to which it is addressed, and 
may contain information that is private, privileged, confidential or exempt 
from disclosure under applicable law. If you are not the intended recipient or 
it appears that this mail has been forwarded to you without proper authority, 
you are notified that any use or dissemination of this information in any 
manner is strictly prohibited. In such cases, please delete this mail from your 
records.

To view this notice in other languages you can either select the following link 
or manually copy and paste the link into the address bar of a web browser: 
http://emaildisclaimer.medtronic.com




___________________________________________________________________________________________________
CONFIDENTIALITY AND PRIVACY NOTICE
Information transmitted by this email is proprietary to Medtronic and is 
intended for use only by the individual or entity to which it is addressed, and 
may contain information that is private, privileged, confidential or exempt 
from disclosure under applicable law. If you are not the intended recipient or 
it appears that this mail has been forwarded to you without proper authority, 
you are notified that any use or dissemination of this information in any 
manner is strictly prohibited. In such cases, please delete this mail from your 
records.

To view this notice in other languages you can either select the following link 
or manually copy and paste the link into the address bar of a web browser: 
http://emaildisclaimer.medtronic.com

Other related posts: