Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Recover from a dropped datafile

Recover from a dropped datafile

From: Ignizio, Richard <richard.ignizio_at_PaeTec.com>
Date: Mon, 13 Feb 2006 22:25:32 -0500
Message-ID: <D63E582D09D77648A106C164FC7C483203C3CFA9@mail1-corp.corp.paetec.com> 





Hello,



I have a situation where a customer has "accidentally" dropped a datafile from a tablespace. The good news is that the datafile was empty since she just added it. The bad news is that there is no backup and it is a 7.3.4 database.



Is it possible to offline the datafile and open the database and some how move the data to a new tablespace?



Thanks,


Rich






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


Received on Mon Feb 13 2006 - 21:25:32 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US