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> 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] *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 >