Re: recover from TRUNCATE TABLE via physical standby?

From: Adric Norris <>
Date: Thu, 23 Aug 2012 17:30:09 -0500
Message-ID: <>

I'll look into that option, but doesn't Flashback Data Archive have to be explicitly enabled for each relevant table? If so, that could be a problem if the number of potential candidate isn't well known up front. On Thu, Aug 23, 2012 at 4:52 PM, Kevin Jernigan <>wrote:

> You could enable Flashback Data Archive (Total Recall) on the table, then
> use Flashback Query to select from the table AS OF a timestamp right before
> the TRUNCATE. This would be much easier to implement, with no need to muck
> around with disconnecting the standby db etc...KJ

Received on Thu Aug 23 2012 - 17:30:09 CDT

Original text of this message