Why doesn Oracle release file space when you drop a tablespace?
Sometimes when you drop a tablespace within Oracle, then remove (rm) the underlying data files, Oracle will not release filesystem space until you shut it down. This can be confirmed with the “df -k” command. This is normal behaviour on Unix machines. If a process has a file open for use, the file will be removed, but the space it occupies will remain in place until all processes referencing it are closed. Use the “fuser” command before deleting Oracle datafiles. If any processes are touching them, you will not get the space back when you rm the file. If SMON is locking your file, just wait a few minutes until it releases it.
Related Questions
- Many professional have questions about Oracle data file and tablespace management, and Ive tried to start this FAQ with common Oracle data file questions. >> Does the amount of free space inside the tablespace containing all the tables inside an OLTP Production database affect its performance?
- Can the Oracle Internet File System (iFS) be integrated with Oracle9iAS Portal?
- Why doesn Oracle release file space when you drop a tablespace?