Hi, What are the business requirements? Do you have users randomly truncating tables or something? It's a bit odd relying on flashback for recovery. Cheers, Phil On 18 Mar 2012, at 14:51, Rumpi Gravenstein <rgravens@xxxxxxxxx> wrote: > The environment: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 > -- //www.freelists.org/webpage/oracle-l