Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Flashback and UNDO_RETENTION

Flashback and UNDO_RETENTION

From: Michael42 <melliott42_at_yahoo.com>
Date: 7 Oct 2006 09:32:29 -0700
Message-ID: <1160238748.954177.112400@i3g2000cwc.googlegroups.com> 





Hello,



In an Oracle 10g R2 database on Solaris 10 I have a table that is
150gb.  Could you please help me determine how big my UNDO_RETENTION
should be set to:



    
  
  1.   To be able to use Flashback Query on this table for up to 24 hours.
  
  2.   To be able to use Flashback Dropped table on this table for up to 24
hours.






Thanks very much,



Michael42
Received on Sat Oct 07 2006 - 11:32:29 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US