Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Filesystem space not freed when drop tablespace

Re: Filesystem space not freed when drop tablespace

From: BD <bobby_dread_at_hotmail.com>
Date: 23 Mar 2006 10:07:09 -0800
Message-ID: <1143137229.248020.259210@u72g2000cwu.googlegroups.com>


>When I do a "drop tablespace MY_TBL_10M including contents and datafiles", then it sometimes happens that the >space in the file system does not get freed.

I had the same thing the other day running 8i on AIX5. Each time I refresh a database, I recreate its temp tablespace, which means making a new TS, dropping the original, and deleting the files. Normally works a treat. Yesterday I had to restart to clear the free space. It was creepy, because the files were gone, but the space was not recognized as freed by the OS. Received on Thu Mar 23 2006 - 12:07:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US