Re: Drop datafile

From: koert54 <k_at_k.com>
Date: Sun, 05 Aug 2001 20:00:17 GMT
Message-ID: <lBhb7.14703$lB.2817429@afrodite.telenet-ops.be>

WOW - if you offline drop a datafile and then delete it (rm, del) you're in for a BIG surprise if in the future you need to do a recovery !

"Michael Austin" <miaustin_at_bellsouth.net> wrote in message news:3B6DA241.C3459E60_at_bellsouth.net...
> Oracle is not a very smart database engine compared to Oracle Rdb
(formerly DEC
> Rdb) and Sql Server in that once you alter... you must then do an OS
delete
> <filename> (rm in Unix, del in NT/OpenVMS etc...)
>
> Micheal Austin
> DBA Consultant
>
> Bernard Bourdon wrote:
>
> > I want to delete an empty datafile that I just created by mistake. I use
the
> > command "alter database datafile 'xxx' offline drop". No error, the
datafile
> > is offline but is not dropped. What can I do ? Can I modify some system
> > tables directly (I would have done that on MS Sql Server in a few
seconds) ?
> >
> > Thanks,
> > Bernard
>
>
Received on Sun Aug 05 2001 - 15:00:17 CDT