Re: recovering data

From: Antonio Da Silva <news_at_nioto.com.NoSpamMerci>
Date: Sun, 19 Jan 2003 15:41:11 +0100
Message-ID: <b0ede7$4mj$1@news-reader7.wanadoo.fr>

Howard J. Rogers wrote:
> "JustAnotherDBA" <jadba_at_bellsouth.net> wrote in message
> news:3g7W9.7161$F_3.6241_at_news.bellsouth.net...
>

>>I thought that 1 of the big benefits of 9i was the ability to access table
>>table as it was previously.
>>
>>In R1 you had to use a DBMS (?) package and in R2 it is simple SQL syntax
>>statements ?
>>
>>Can anyone comment on this?

>
>
> It's called flashback. And yes, in 9iR1 you had to execute
> dbms_flashback.enable_at_time(sometime) or exec
> dbms_flashback.enable_at_scn(some SCN). Then all your selects were performed
> as of that time or SCN, provided the rollback was available to construct the
> required state of the data.
>

Thanks a lot , I recover my data with a flashback , it's a powerfull toy :-)

Tonio Received on Sun Jan 19 2003 - 08:41:11 CST