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_at_medtronic.com> 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_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *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
>

--
http://www.freelists.org/webpage/oracle-l