Re: Drop Tablespace not releasing space ?

From: R.S. <info_at_bytelife.com>
Date: Thu, 8 Jul 2004 13:04:20 +0200
Message-ID: <40eed02d$0$66826$a344fe98@news.wanadoo.nl>

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 -

"Krist" <xtanto_at_hotmail.com> schreef in bericht

> 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
Received on Thu Jul 08 2004 - 06:04:20 CDT