Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Filesystem space not freed when drop tablespace
>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