Drop Tablespace not releasing space ?

[Krist]

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

[Roman]

Post by Krist
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

[Daniel Morgan]

Post by Roman

Post by Krist
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

[R.S.]

Hello Kirst,
This a normal behaviour on all unix systems.
You have to bounce to make unix "aware" the files are no longer in use.
You can resize (downsize) the datafiles before dropping on 24 x 7 systems.
That works fine.

Cheers

Roelof Schierbeek

Anyone who's lived thought an english winter can see the point of building
Stonehenge -

Post by Krist
I am new to both Oracle 9i and AIX 5.
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

[Joel Garry]

Post by Krist
Hi All,
I am new to both Oracle 9i and AIX 5.
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/