Re: drop tablespace, delete datafiles, but space not returned?

[EMAIL PROTECTED] (yls177) wrote in message news:<[EMAIL PROTECTED]>...
> "Oradba Linux" <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>...
> > On Mon, 24 Nov 2003 09:07:44 +0000, yls177 wrote:
> > 
> > > i am on sap. and drop a tablespace through sapdba.
> > > 
> > > SAPDBA: ORACLE has obviously not released the filesystem space of
> > > 17811928 K(Before: 5453816 K, Now: 5453828 K, 100 K reserve for log
> > > info, ...).This sluggish behavior is well known. It will take a few
> > > minutes or a DB reboot to release all the space!
> > > 
> > > and i checked my vg, lv... the space did not increase.
> > > 
> > > i need to do a restart of oracle to get back the used space?
> > 
> > I have seen this happen sometimes . It is with Unix and open files . 
> > Sometimes when you delete a file from Unix with some process
> > still writing to it , the space does not get released . It has
> > something to do with inodes .
> 
> thanks.. so one of the ways to see these space is to bounce the database?

okay.. i think i know what went wrong.... after dropping the
tablespaces and removing the datafiles , the space is not reclaimed
back to the volume group cos they are still in use by the filesystem
in the logical volume.so what i need to do is to reduce the size of
the filesystem. of course, i should NOT reduce beyond the size of the
existing filesystem. so after doing that, the free space will be
returned to the volume group, right?

also

1) i can reduce the size of the filesystem without affecting any other
stuff. all i need to ensure is that i reduce the space so that there
are enough for the existing data