Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: weird missing datafile question

Re: weird missing datafile question

From: Big Al <db-guru_at_att.net>
Date: 2000/05/31
Message-ID: <3935A254.6CCAD879@att.net>#1/1

It's the same answer. Oracle has the file open and already has a connection via UNIX to the correct location. Once it is deleted, you can't see the path from anywhere else. Try this (assuming you have a sandbox system to play in), with Oracle up and the datafile open, delete the datafile and then try and delete the directory in UNIX. Have fun.

Al

kal121_at_my-deja.com wrote:
>
> OK, I can buy this - but the path is no longer correct - or does UNIX
> keep that information around too?
>
> In article <392EEB17.60DD7C9E_at_att.net>,
> db-guru_at_bigfoot.com wrote:
> > If you're on UNIX it makes perfect sense. UNIX doesn't physically
> > delete the file until the use count drops to 0. Even though you
> > logically deleted it, it is still physically on disk until Oracle is
> > brought down or the file is deallocated.
> >
> > Big Al
> >
> > kal121_at_my-deja.com wrote:
> > >
> > > I've been doing some experimenting lately and noticed some "strange"
> > > behavior.
> > >
> > > For example:
> > > I delete my users01.dbf datafile while the database is open. I
 still am
> > > able to make modifications to the tables in this tablespace (due the
> > > changes being buffered in memory and not being written to the
 datafiles
> > > directly).
> > >
> > > Next, I issue an ALTER SYSTEM SWITCH LOGFILE - which should force
 the
> > > dirty buffers to be written out the the datafiles, right? So how
 come I
> > > don't get any error messages when I do this, even though the
> > > users01.dbf file is gone??? The switch logfile completes
 successfully.
> > >
> > > I find this perplexing.
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
  Received on Wed May 31 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US