Re: Help with recovery

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Thu, 29 Apr 2004 10:59:19 GMT
Message-ID: <be5kc.123238$M3.51583@twister.nyroc.rr.com>

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:4090a109$0$674$afc38c87_at_news.optusnet.com.au... --snip--
>
> Ah, but you cheated! You did a delete, which can certainly be
> flashbacked from (I hate the grammar, but hopefully you know what I
> mean!). The original poster didn't say, but you can't flashback past DDL
> commands (until 10g, anyway) -so if his problem was that the original
> table was dropped, rather than bulk-deleted, flashback in 9i isn't going
> to help him any.
>
> As a general point, though, the idea that flashback can help us avoid
> the need to perform incomplete recoveries is an extremely important one.
>
> Regards
> HJR
True :)

If I had done a truncate/drop .. I couldn't have flashbacked. Though a lot of user errors revolve around deletes/updates gone bad. So I thought I'll throw in that example ... just in case.

Anurag Received on Thu Apr 29 2004 - 05:59:19 CDT