Re: oracle total recall
From: Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
Date: Tue, 3 Apr 2012 14:10:58 +0200
Message-ID: <4F7AE8D2.9060203_at_nordea.com>
W dniu 03.04.2012 13:36, Ilmar Kerm pisze:
> On Tue, Apr 3, 2012 at 2:00 PM, Remigiusz Sokolowski
> <remigiusz.sokolowski_at_nordea.com> wrote:
[..]
> I somehow got the feeling, that maybe you are mixing up two different
> flashback features:
> * flashback database, for a very quick entire database rollback
> * flashback archive (total recall), mainly for providing historical
> views of a table data for a long period in time, by storing the needed
> undo records
>
Date: Tue, 3 Apr 2012 14:10:58 +0200
Message-ID: <4F7AE8D2.9060203_at_nordea.com>
W dniu 03.04.2012 13:36, Ilmar Kerm pisze:
> On Tue, Apr 3, 2012 at 2:00 PM, Remigiusz Sokolowski
> <remigiusz.sokolowski_at_nordea.com> wrote:
[..]
> I somehow got the feeling, that maybe you are mixing up two different
> flashback features:
> * flashback database, for a very quick entire database rollback
> * flashback archive (total recall), mainly for providing historical
> views of a table data for a long period in time, by storing the needed
> undo records
>
That is an interesting statement.
I certainly do not use flashback database, but flashback table
statements (thus this will use data from UNDO tablespace).
So, if I understand You well, my idea that flashback table will use
flashback archives if called on flashback-archive-enabled table is not
really a reality ? ;-)
That would be something I look for.
Regards
Remigiusz
-- 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 siedzibą w Gdyni, ul. Kielecka 2, 81-303 Gdynia, wpisaną do Rejestru Przedsiębiorców Krajowego Rejestru Sądowego pod numerem: 0000021828, dla której dokumentację przechowuje Sąd Rejonowy Gdańsk - Północ w Gdańsku, VIII Wydział Gospodarczy Krajowego Rejestru Sądowego, o kapitale zakładowym i wpłaconym w wysokości: 277.493.500,00 złotych, NIP: 586-000-78-20, REGON: 190024711-- http://www.freelists.org/webpage/oracle-lReceived on Tue Apr 03 2012 - 07:10:58 CDT