Re: oracle total recall

  • From: Remigiusz Sokolowski <remigiusz.sokolowski@xxxxxxxxxx>
  • To: Rumpi Gravenstein <rgravens@xxxxxxxxx>
  • Date: Tue, 3 Apr 2012 15:25:31 +0200

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@xxxxxxxxxx>
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-l


Other related posts: