Re: Flashback Schema ... any ideas

From: April Sims <aprilcsims_at_gmail.com>
Date: Wed, 22 Feb 2012 10:21:44 -0600
Message-ID: <CAK+cZDem4ymGupRWvrEE7Ajed7+RAQhDd_HmTQnFunak5q7_Nw_at_mail.gmail.com>



Mihajlo,
How about Transportable Tablespaces?

April C. Sims
IOUG SELECT Journal Executive Editor
http://aprilcsims.wordpress.com
Twitter, LinkedIn
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
aprilcsims_at_gmail.com

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).
>
> ~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-l
>
>
>

--

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Feb 22 2012 - 10:21:44 CST

Original text of this message