Re: Drop Tablespace not releasing space ?

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 09 Jul 2004 15:39:04 -0700
Message-ID: <1089412759.556675@yasure>

Roman wrote:

> Am Fri, 09 Jul 2004 00:59:13 -0700 schrieb Krist:
>
>

>>I create tablespace with 10 datafiles @ 1GB , and drop it from TOAD.
>>It doesn't release the space back until Oracle Shutdown.
>>Is this a normal behaviour or s'thing wrong here ?
>>

>
>
> Hello,
>
> I can't really tell what TOAD does, but if you drop a TSP with sqlplus,
> you have to delete the datafiles manually on file system level if you
> want to get rid of them.
>
> Roman

No you don't. The syntax is:

DROP TABLESPACE <tablespace_name> INCLUDING CONTENTS AND DATAFILES;

Daniel Morgan Received on Fri Jul 09 2004 - 17:39:04 CDT