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. > > > > > > > -- > //www.freelists.org/webpage/oracle-l > > > -- -- //www.freelists.org/webpage/oracle-l