Re: Not able to find data file on server but database is working fine

  • From: Michael Haddon <m.haddon@xxxxxxxxx>
  • Date: Fri, 22 Jun 2007 14:58:59 -0600

Patrick has this exactly right. - the only *real* way to prove it is to bounce the database and then you will have lost all the data. I would recommend that you create the table in another tablespace exactly like Patrick says then bounce the database. you can prove the theory and still keep your data. The other option to bouncing the DB is to drop the tablespace and data file, but that won't prove anything.


Another way to show this is to look at the file system usage. It should still reflect the file that is not shown in Unix but is still open in the database. The space is not released until the file is truly gone.

Hope this helps
Mike

Elliott, Patrick wrote:
I didn't mention ASM.  ASM is a different animal altogether, and I
understand that you are able to insert data and use the file.

Here is the way it works...
When you open a file in UNIX, you are opening an i-node.  When you
delete a file, the i-node does not get released until all processes that
have it open close it.  Oracle still has the file open, so the i-node is
in use and the database does not even know that the file has been
deleted.


Pat


--
//www.freelists.org/webpage/oracle-l


Other related posts: