Re: Some plonker typed rm temp.dbf AAARRGGHHH!

From: Julio <julio.negueruela_at_si.unirioja.es>
Date: Thu, 30 Jul 1998 12:33:25 +0200
Message-ID: <35C04BF5.D3D244D@si.unirioja.es>

Winnie Liu escribió:
> =

> I think you can bring a tablespace offline and drop it whether you are =
using
> archive log or no archivelog. The only different is that if you are wor=
king
> in archive log mode. You can bring it offline and then open the rest of=
 the
> database. ANd then try to recover that tablespace/datafile. While if yo=
u are
> in noarchive log mode, you cannot recover the file/tablespace but only =
to
> drop it.

In order to avoid enabling archive I just talked about puting offline a datafile, not a tablespace. So, you can put the datafile offline and drop the tablespace.
 =

> I hope memory serves for me too. If I am wrong about the above, please =
do
> correct me. Thanx =>
> =

> Winnie

Regards.
-- =

Julio Negueruela
DBA Servicio Informático

Universidad de La Rioja      -      Spain
Telf: 941-299179     Fax: 941- 299180

mailto:julio.negueruela_at_si.unirioja.es Received on Thu Jul 30 1998 - 05:33:25 CDT