Re: Flashback Schema ... any ideas
From: Mihajlo Tekic <mihajlo.tekic_at_gmail.com>
Date: Wed, 22 Feb 2012 10:14:56 -0600
Message-ID: <CAGWRspZH-mg31jD7dEN1=oQFp40gVRJC194MifhcgbVdZTZzYA_at_mail.gmail.com>
Hi Christopher,
Thanks for the input.
Date: Wed, 22 Feb 2012 10:14:56 -0600
Message-ID: <CAGWRspZH-mg31jD7dEN1=oQFp40gVRJC194MifhcgbVdZTZzYA_at_mail.gmail.com>
Hi Christopher,
Thanks for the input.
We considered that. The challenge is that with this option we would need supplemental logging enabled. We faced some problems using supplemental logging (in-memory undo disabled, Bugs with Spatial data type). In 11g Flashback Transaction Backout does pretty much the same thing.
Another problem could be the time needed to mine the logs and reconstruct all the changes (record by record).
~Mihajlo
On Wed, Feb 22, 2012 at 9:53 AM, Newman, Christopher <cjnewman_at_uillinois.edu
> wrote:
> If you know the timeframe and it's isolated to a specific schema; one
> could use logminer to find the sql to undo the changes.
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 22 2012 - 10:14:56 CST