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 -> Re: Building app around Flashback Versions Query

Re: Building app around Flashback Versions Query

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 2 Dec 2005 06:54:58 +0100
Message-ID: <438fe1b1$0$652$626a14ce@news.free.fr>

<bdbafh_at_gmail.com> a écrit dans le message de news: 1133475997.052657.130690_at_g49g2000cwa.googlegroups.com...
|I don't have the info in front of me, but in 9.2 I believe that the
| controlfile_keep_time limited the range to 5 days in the past. This may
| be a non-issue in 10g R1.
|
| -bdbafh
|

Please just run an eye over the doc before posting something you're not sure of (9.2): CONTROL_FILE_RECORD_KEEP_TIME

      Parameter type
     Integer

      Default value
     7 (days)

      Parameter class
     Dynamic: ALTER SYSTEM

      Range of values
     0 to 365 (days)



Regards
Michel Cadot Received on Thu Dec 01 2005 - 23:54:58 CST

Original text of this message

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