Re: OFFLINE DROP

No..by all means put the file back...
alter database create datafile 'xxxxx'
alter database recover datafile 'xxxx';
If it is really empty, which you can find out in dba_extents view, just re-size it to something lower than the minimum extent that will ever be used.
The ONLY way to get rid of it is to drop and re-create the tablespace, which may not be an option depending on the size. Of course, this scenario assumes you've already removed the file from the operating system, if you haven't, you just need to recover the file as far as I know..

• Dc.

On Fri, 28 Apr 2000 18:40:09 GMT, mgallego_at_ahs.llumc.edu wrote:

>
>
>Here's an interesting scenario:
>
>We have two datafiles for an index table space. One of the
>datafiles is empty. We performed an alter database offline
>drop to drop the empty datafile. Instead of it going offline
>and being dropped, it went into recover mode.
>
>Question: Is there a way to drop the empty datafile without
>blowing away the tablespace?
>
>Mernyl
>
>P.S. Kindly reply to this post and to my e-mail address at
>mgallego_at_ahs.llumc.edu. Thanks!
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Sat Apr 29 2000 - 00:00:00 CDT