Re: weird missing datafile question

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.
Received on Fri May 26 2000 - 00:00:00 CDT