Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: weird missing datafile question
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 Tue May 30 2000 - 00:00:00 CDT