Just yesterday I did a "drop tablespace ... including contents and datafiles" (9.2.0.6 on Solaris). The filesystem space freed up later, but not immediately after the drop. Paul Baumgartel paul.baumgartel@xxxxxxxxxxxxxxxxx 212.538.1143 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Mercadante, Thomas F (LABOR) Sent: Thursday, April 20, 2006 2:43 PM To: Oracle-L Freelists Subject: Unix Command All, There is a unix command to show who has what files open on a mount point - anybody remember what it is? We dropped a tablespace along with the data files, but the space was not released. I'm thinking that somehow Oracle did not release the space yet. Anybody remember something like this? This is on Sun Solaris/9.2.0.5. Thanks Tom -- //www.freelists.org/webpage/oracle-l ============================================================================== Please access the attached hyperlink for an important electronic communications disclaimer: http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html ============================================================================== -- //www.freelists.org/webpage/oracle-l