RE: i ReMoved the RBS datafile !!

From: Gilles PARC <gparc_at_online.fr>
Date: Thu, 11 May 2000 19:32:04 +0200
Message-Id: <10494.105430@fatcity.com>

Hi Bruce,

At 06:06 08/05/2000 -0800, you wrote:
<I know someone that deleted a production database, then realized what he did. He got all <the users out and did a full export of the database before shutting it down. He then <recreated the database and imported everything back in.

Can you be more specific about that case (OS, Oracle version,files destroyed...) ?

Because as i agree that processes already connected can still "see" the removed
DB files, in dedicated server configuration, export uses a NEW oracle process (two-task or single-task mode) and as such it cannot open previously destroyed datafiles.
Was it a Muti-threaded server configuration ??

Thanks in advance for clarifications

Regards

Gilles Parc
Email : gparc_at_mail.dotcom.fr Received on Thu May 11 2000 - 12:32:04 CDT