Re: can't drop tablespace

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 2000/03/29
Message-ID: <8bsh4f$3lh$1@ctb-nnrp1.saix.net>#1/1

junfan wrote in message <38E19A62.B0CB329A_at_bigfoot.com>...
>
>I delete the datafiles belonging to a tablespace mistakenly. afterwards,
>I couldn't drop the corresponding tablespace by "drop tablespace..."
>statement. How can I drop the tablespace ?

Try making those deleted datafiles offline and dropping them first. The statement I think is ALTER DATABASE DATAFILE <filename> OFFLINE DROP

Then retry the DROP TABLESPACE statement.

regards,
Billy Received on Wed Mar 29 2000 - 00:00:00 CST