Good point, Dan. If using SCN to flashback then it's a non-issue.
Avoid using date/time stamp to flashback during that 1 hour period. Or find out the SCN from SYS.SMON_SCN_TIME table closest to the past time, and use it to flashback. - Kirti --- Daniel Fink <[EMAIL PROTECTED]> wrote: > Another thought for 9i...how would a time change impact flashback query? > > Daniel Fink > david davis wrote: > > > Another issue might be related to doing time-based recovery. Oracle has a > > couple of notes on metalink related to changing server time and database > > impact. > > > > Note:1013279.6 - HOW DOES DAYLIGHT SAVINGS TIME AFFECT THE DATABASE? > > Note:77370.1 - What are the effects of changing the system clock on an > > Oracle Server instance? > > > > >From: Stephane Faroult <[EMAIL PROTECTED]> > > >Reply-To: [EMAIL PROTECTED] > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > >Subject: Re: Effect on Oracle of changing server time from EST to GMT > > >Date: Thu, 16 Oct 2003 15:04:40 -0800 > > > > > >Well, some jobs (including snapshot refreshes) may get confused, and if > > >you create or alter objects I wonder how Oracle may handle dependencies > > >... Fortunately you are moving 5 hours ahead, rather than back, so risks > > >are probably quite limited. > > > > > >-- > > >Regards, > > > > > >Stephane Faroult > > >Oriole Software __________________________________ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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).