Re: Merge datafile to Another DATABASE
Date: Fri, 11 Jan 2008 08:43:41 -0800
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
and build a new db . Please correct me if It is not what you meant.
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.
> *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
> 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?
> * *
> 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