Tom The command to see what user has a file open is fuser. I have had this exact problem on Solaris. The solution was to restart the Oracle instance. Now when I have to drop a tablespace on Solaris and I can't reboot. I drop the contents of the tablespace and then resize it down to (say) 1Mb. That space (former size of tablespace -1Mb) is then released at the OS level immediately. I can then drop the tablespace and the extra 1Mb will be available after the next reboot. Ray > -----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