weird missing datafile question

From: <kal121_at_my-deja.com>
Date: 2000/05/26
Message-ID: <8gmoel$ons$1@nnrp1.deja.com>#1/1

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