RE: Merge datafile to Another DATABASE
Date: Fri, 11 Jan 2008 09:55:33 -0600
Message-ID: <3B8B6A1700202C43A89D61CE495C894E0D037CE6BC@MSPM1BMSGM103.ent.core.medtronic.com>
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-lReceived on Fri Jan 11 2008 - 09:55:33 CST