Re: datafile deleted and no backup at all

zhangc a écrit :
>
> 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

If the datafile is from a REAL temporary tablespace (i mean just sort segments
are stored in it), do the following :

• startup mount the database
• alter database datafile '....' offline drop;
• alter database open;
• drop tablespace TEMP including contents;
• recreate the tablespace