Recover from a dropped datafile

  • From: "Ignizio, Richard" <richard.ignizio@xxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 13 Feb 2006 22:25:32 -0500

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





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


Other related posts: