Re: Flashback Schema ... any ideas

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@xxxxxxxxx


On Wed, Feb 22, 2012 at 10:14 AM, Mihajlo Tekic <mihajlo.tekic@xxxxxxxxx>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@xxxxxxxxxxxxx
> > 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


Other related posts: