Re: Drop datafile

From: Michael Austin <miaustin_at_bellsouth.net>
Date: Sun, 05 Aug 2001 15:45:06 -0400
Message-ID: <3B6DA241.C3459E60@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 - 14:45:06 CDT