OFFLINE DROP

From: <mgallego_at_ahs.llumc.edu>
Date: 2000/04/28
Message-ID: <8eclu6$f3j$1@nnrp1.deja.com>#1/1

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 Fri Apr 28 2000 - 00:00:00 CDT