Re: Drop Tablespace not releasing space ?

xtanto_at_hotmail.com (Krist) wrote in message news:<cb48a3b.0407082359.64041e3_at_posting.google.com>...
> Hi All,
>
> I am new to both Oracle 9i and AIX 5.
> 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 ?
>
> Thank you for any help,
> Krist

Various versions of Oracle don't release one or more datafiles until shutdown. On unix, you can rm a file, which removes it's inode, but any processes that are using the file will keep it around until they close it. man fuser to see how to figure out what is holding it open.  There used to be a bug in Oracle that it wouldn't close the last file until shutdown, but I thought that was fixed.

jg

--
@home.com is bogus.
http://www.theregister.co.uk/2004/07/09/419_scam_anatomy/