Bambi, Are you using automatic undo management or manual? I think that flashback can only be used with auto.
Stephen >>> [EMAIL PROTECTED] 11/06/03 10:04AM >>> 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert 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).