Re: can't drop tablespace

A variation is to create the datafiles, then drop the tablespace. 'Alter tablespace fred create datafile 'tom' size 1M;  drop tablespace fred;
'

In article <8bsh4f$3lh$1_at_ctb-nnrp1.saix.net>, "Billy Verreynne" <vslabs_at_onwe.co.za> wrote:
> 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
>
>

--
Joseph R.P. Maloney, CCP,CSP,CDP
MPiR, Inc.
502-451-7404
some witty phrase goes here, I think.


Sent via Deja.com http://www.deja.com/
Before you buy.