Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: re-create tablespace
'Offline drop' is really the command to take datafiles offline when in
noarchivelog mode. Which means that the 'drop' syntax is really fairly
redundant in archivelog mode: at least, it doesn't do any more damage than a
plain old 'offline' would do.
Therefore, it should be perfectly possible to restore the accidentally deleted file, perform recovery on that file, and then online it.
Regards
HJR
"Vadim Grepan" <kezal_at_mail.ru> wrote in message
news:3CE60815.9905EE7A_at_mail.ru...
> Hello All!
>
> is it necessery to re-create tablespace after clause ALTER DATABASE
> DATAFILE 'xxx' OFFLINE DROP?
> One datafile has been deleted accidently but the rest of tablespace is
> OK (i know what i say)
>
> Vadim
> ---------------------
> Moscow, Russia
>
>
Received on Sat May 18 2002 - 21:08:59 CDT