Re: oracle total recall
From: Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
Date: Tue, 3 Apr 2012 15:25:31 +0200
Message-ID: <4F7AFA4B.9060804_at_nordea.com>
W dniu 03.04.2012 15:14, Rumpi Gravenstein pisze:
> 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.
>
Would You be more elaborate?
I do not catch Your point - I do not move the data. Possibly I could export data before processing, then do processing, then import again if something went wrong, but it would take too much time.
Date: Tue, 3 Apr 2012 15:25:31 +0200
Message-ID: <4F7AFA4B.9060804_at_nordea.com>
W dniu 03.04.2012 15:14, Rumpi Gravenstein pisze:
> 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.
>
Would You be more elaborate?
I do not catch Your point - I do not move the data. Possibly I could export data before processing, then do processing, then import again if something went wrong, but it would take too much time.
-- Pole nakazi ---------------------------------------------------------------------- Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com> pos : DBA at DIiUSI addr : Nordea Bank Polska SA, Luzycka 6A Street, 81-537 Gdynia, Poland phone : +48 58 667 17 43 mobile: +48 602 42 42 77 Nordea Bank Polska S.A. z siedziba w Gdyni, ul. Kielecka 2, 81-303 Gdynia, wpisana do Rejestru Przedsiebiorców Krajowego Rejestru Sadowego pod numerem: 0000021828, dla której dokumentacje przechowuje Sad Rejonowy Gdansk - Pólnoc w Gdansku, VIII Wydzial Gospodarczy Krajowego Rejestru Sadowego, o kapitale zakladowym i wplaconym w wysokosci: 277.493.500,00 zlotych, NIP: 586-000-78-20, REGON: 190024711-- http://www.freelists.org/webpage/oracle-lReceived on Tue Apr 03 2012 - 08:25:31 CDT