Re: datafile deleted and no backup at all

Since it is the temporary tablespace, I think you can recover by:

1.  starting up the database (nomount).
2.  alter the temp tablespace offline.
3.  drop the temp tablespace.
4.  recreate your temporary tablespace.

This is off the top of my head. Anyone out there, please correct me if I am wrong.

Scott

"zhangc" <zhangc_at_netcom.ca> wrote in message news:iPHR4.37803$Xk2.137239_at_tor-nn1.netcom.ca...
> I accidentally deleted datafile for the temp tablespace and we don't have
> any backup and the database is running in noarchivelog mode. I tried to
> alter database create datafile ... shutdown the database... and now I
 cannot
> open the database at all since it always asks for "media recovery" and
 seems
> like there is nothing I can do but recreate the database, and loss all the
> data,although it's not very important data.
>
> Any help will be very much appreciated.
>
> Chuck
>
>
Received on Mon May 08 2000 - 00:00:00 CDT