Re: Merge datafile to Another DATABASE

From: Prasad <>
Date: Fri, 11 Jan 2008 08:43:41 -0800
Message-ID: <>

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.


On Jan 11, 2008 7:55 AM, Elliott, Patrick <> 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:* [mailto:
>] *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
> ___________________________________________________________________________________________________
> 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:

Received on Fri Jan 11 2008 - 10:43:41 CST

Original text of this message