Re: Flashback Schema ... any ideas
Date: Wed, 22 Feb 2012 10:21:44 -0600
How about Transportable Tablespaces?
April C. Sims
IOUG SELECT Journal Executive Editor
Oracle Database 11g – Underground Advice for Database Administrators https://www.packtpub.com/oracle-11g-database-implementations-guide/book OCP 8i, 9i, 10g, 11g DBA
Southern Utah University
On Wed, Feb 22, 2012 at 10:14 AM, Mihajlo Tekic <mihajlo.tekic_at_gmail.com>wrote:
> 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).
> On Wed, Feb 22, 2012 at 9:53 AM, Newman, Christopher <
> > 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.