Re: oracle total recall
From: Rumpi Gravenstein <rgravens_at_gmail.com>
Date: Tue, 3 Apr 2012 09:14:33 -0400
Message-ID: <CAEpg1wAnbkk-XB-111iOOcuHjKZ4FokxrDS-4OQqCsXT1Sq5Gw_at_mail.gmail.com>
>
> I wonder if anybody used this (total recall/flashback table) feature and
> what are Your impressions?
>
Before you dive to deeply into flashback tables, you should consider the impact on data recovery and migration. Specifically there is no easy way (possibly no way) to move this data, table at a time, from one database to another or even to backup just a table. Hopefully Oracle will address this short fall in an upcoming release.
Date: Tue, 3 Apr 2012 09:14:33 -0400
Message-ID: <CAEpg1wAnbkk-XB-111iOOcuHjKZ4FokxrDS-4OQqCsXT1Sq5Gw_at_mail.gmail.com>
>
> I wonder if anybody used this (total recall/flashback table) feature and
> what are Your impressions?
>
Before you dive to deeply into flashback tables, you should consider the impact on data recovery and migration. Specifically there is no easy way (possibly no way) to move this data, table at a time, from one database to another or even to backup just a table. Hopefully Oracle will address this short fall in an upcoming release.
-- Rumpi Gravenstein -- http://www.freelists.org/webpage/oracle-lReceived on Tue Apr 03 2012 - 08:14:33 CDT