Re: Datafile lost

From: Kevin Loney <Kevin.Loney_at_astramerck.com>
Date: Tue, 22 Sep 1998 10:10:38 -0400
Message-ID: <EdON1.1348$lO3.1231512@newsread.com>

If you get really lucky, you'll be able to do an

ALTER DATABASE DATAFILE 'filename' OFFLINE DROP;

but you'll lose all of the contents in that datafile in the process.

Kevin.
http://www.kevinloney.com

cdoganay_at_my-dejanews.com wrote in message <6u5kl8$sgr$1_at_nnrp1.dejanews.com>...
>Hi, I was testing some disaster recovery scenarios. The case is that
>1) I lost 1 datafile belonging to 1 tablespace
>2) I have no backup after RESETLOGS issues, except export of required
tables
>3) I can not open database
>4) How can I open database and import the required tables?
>
>Cemal
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Tue Sep 22 1998 - 09:10:38 CDT