Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Datafile lost
Thank you very much. It worked fine.
Cemal
In article <EdON1.1348$lO3.1231512_at_newsread.com>,
"Kevin Loney" <Kevin.Loney_at_astramerck.com> wrote:
> 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
>
>
-----== 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 - 15:47:16 CDT