Re: Drop datafile

Been there, done this.. If you're in archive log mode, I would suggest putting the file back. alter database create datafile 'etc.,etc.etc.,' and recover it. (which you may need to do even though it is empty)

Basic rule of thumb is once you've added a file to Oracle, leave it there. You won't be doing yourself any favors by playing around. You probably have a 'RECOVER' status in v$datafile for this file or something. It will just make things harder later.

• Doug

On Sun, 5 Aug 2001 20:35:38 +0200, "Bernard Bourdon" <bernard.bourdon_at_pi.be> 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 Mon Aug 06 2001 - 01:05:39 CDT