Re: recover from TRUNCATE TABLE via physical standby?
From: Adric Norris <landstander668_at_gmail.com>
Date: Fri, 24 Aug 2012 08:32:01 -0500
Message-ID: <CAJueESo4xV4+4qp9R_fXYNvv+2JqWyq7JNU1WDMhbxv1g9tFiQ_at_mail.gmail.com>
Yeah, that's basically it. The system I'm currently concerned with is a lightly controlled (mostly) DW environment, with quite a few business analysts that have the ability to create/alter/truncate/etc. various items. Good or bad, that would make it difficult to ensure that all of the potentially-required tables are configured appropriately for Flashback Data Archive (not to mention keeping the list up to date). I'll definitely keep the suggestion in mind, however... I can think of a few other databases where it might be of interest. :)
Date: Fri, 24 Aug 2012 08:32:01 -0500
Message-ID: <CAJueESo4xV4+4qp9R_fXYNvv+2JqWyq7JNU1WDMhbxv1g9tFiQ_at_mail.gmail.com>
Yeah, that's basically it. The system I'm currently concerned with is a lightly controlled (mostly) DW environment, with quite a few business analysts that have the ability to create/alter/truncate/etc. various items. Good or bad, that would make it difficult to ensure that all of the potentially-required tables are configured appropriately for Flashback Data Archive (not to mention keeping the list up to date). I'll definitely keep the suggestion in mind, however... I can think of a few other databases where it might be of interest. :)
On Thu, Aug 23, 2012 at 5:55 PM, Kevin Jernigan <kevin.jernigan_at_oracle.com>wrote:
> Yes, you do have to enable Flashback Data Archive for each table
> individually. But I don't understand what you mean by "...if the number of
> potential candidate isn't well known up front.": are you saying that you
> might not know which tables you need to enable FDA on before you truncate
> them?
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 24 2012 - 08:32:01 CDT