Joel Garry wrote:
> "Anurag Varma" <avdbi_at_hotmail.com> wrote in message news:<be5kc.123238$M3.51583_at_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
>
>
> I thought 10g had a recycle bin for that...
> http://download-west.oracle.com/docs/cd/B13789_01/server.101/b10759/statements_9003.htm#sthref6370
10g DOES have a recycle bin for that. Which is precisely why I wrote
"you can't flashback past DDL commands (until 10g, anyway)".
HJR
Received on Fri Apr 30 2004 - 17:16:49 CDT
