Hi! It was only the SCN <-> time mapping informatin which is aged out after 5 days, but you still can use SCN-based flashback back to your oldest undo record.
Tanel. ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, November 07, 2003 10:04 PM > Others have mentioned it, but I just wanted to chime in to warn you to warn > your developers, that they will only have five days to use their frozen > moment in time. This is the limitation imposed by the scn table mentioned > in Dan's post. The reason I decided to chime in is that AFAIK, no official > Oracle documentation refers to this limitation. This is just one of those > odd things I wouldn't know, if it weren't for my association to this list. > > -----Original Message----- > Bellow, Bambi > Sent: Friday, November 07, 2003 8:19 AM > To: Multiple recipients of list ORACLE-L > > > Melanie -- > > What's happening is that, in a write-intensive environment, the developers > want to "freeze a moment in time" which can be used across developers and > applications for testing to ensure consistent results. The functionality > may be expanded, in time, depending on how it works. But from what I'm > seeing, this seems to be the right tool for the job. > > Thanks, everyone, for your feedback. In my book, this goes down as Oracle's > coolest feature since DECODE. > > Bambi. > > -----Original Message----- > Sent: Thursday, November 06, 2003 11:45 AM > To: Multiple recipients of list ORACLE-L > > > Hi Bambi, > > I hate to sound repetitive, but, it depends. :-) > > It depends on how far you want to flash back to. > > One of my clients was being audited last year by their > parent company. > > I put in a retention period of about a week at a time. > > Without divulging much from my confidentiality > agreement with them, we were really trying to figure > out what certain users were doing within the company, > and we provided proof of such. Using the flashback > query feature made this incredibly easy to do! > > Of course, you have to be careful with your UNDO > segments, as you know. > > I didn't try going backwards for more than a week. > That was all we needed at the time. > > I also turned this feature off once we were done. > > Other than UNDO segment growth, which I planned for in > advance, I didn't have any problems with it. And it > made the task at hand incredibly easy. > > But, I wouldn't recommend putting it in place unless > you really need it. > > My $0.02, > Melanie > > --- "Bellow, Bambi" <[EMAIL PROTECTED]> wrote: > > Hi Folks! > > > > I got waylaid(?) when I got in this morning and > > these user dudes were > > talking about using flashbacks, and I was like > > "Woah! Dudes! Let's just > > chill on this for a couple of minutes". So, I went > > back to my desk and > > checked out a cool article on it... > > > > > http://www.oracle-base.com/Articles/9i/FlashbackQuery.asp > > > > And it looks like it's like, killer, yknow? So, I > > was thinking "well, we've > > got sufficiently large undo segments for this, I > > don't see a problem with > > it" but that didn't sound terribly cool, and anyway, > > before I go willy-nilly > > saying this is the niftiest thing Oracle's done in > > years, I thought I would > > run it by you guys and see if anybody out there is > > running with flashbacks > > and whether there have been any problems with it. > > > > Yer far-out pal, > > Bambi. > > > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.net > > -- > > Author: Bellow, Bambi > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 > > http://www.fatcity.com > > San Diego, California -- Mailing list and web > > hosting services > > > --------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (or the name of mailing list you want to be removed > > from). You may > > also send the HELP command for other information > > (like subscribing). > > > __________________________________ > Do you Yahoo!? > Protect your identity with Yahoo! Mail AddressGuard > http://antispam.yahoo.com/whatsnewfree > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Melanie Caffrey > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Bellow, Bambi > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Steve McClure > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).