Re: Drop Tablespace not releasing space ?

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 Received on Fri Jul 09 2004 - 08:28:58 CDT