The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > UNIX for Dummies Questions & Answers
Google UNIX.COM



View Single Post in UNIX Forums - Click on the Thread or Permalink to View Entire Thread -->
  #3 (permalink)  
Old 03-13-2007
sb008 sb008 is offline
Registered User
 

Join Date: Jan 2007
Posts: 366
Quote:
Originally Posted by BOFH
Sounds like Oracle is probably still holding on to the files. You'd have to stop and start Oracle (assuming that's what's holding it) which would clear it.

Carl
Correct

If some kind of process has opened a file, it still possible for you to delete the file at the command line.

Visually it will look as if the file has been removed.

However, underneath the file is still there. Only when the process, which opened the file, closes the file, the file will be really removed and the data blocks which made up the file will be free'd.

As BOFH already mentioned the most likely candidate for who has the files opened is one of the Oracle processes.

So you indeed have to shut down Oracle to get the space back which was taken by the file.

Furthermore, I hope for you you don't end up with a totally damaged and corrupt database.

It is not smart to remove files like that. There is a good chance you removed part if not all of the database.
Reply With Quote