Re: Oracle and DST changes

If you concentrate on the following 4 alone, a clearer picture should emerge. I 
am assuming you donot have any App.Srvr , OID stuff etc.

Note  : 359145.1 Impact of 2007 USA daylight saving changes on the Oracle 
database
Note  : 340512.1 Timestamps & time zones - Frequently Asked Questions
Note  : 397281.1 USA 2007 Daylight Saving Time (DST) Compliance for Database 
and Fusion Middleware
Note  : 396426.1 Effects on client and middle-tier of applying time zone 
patches on the Oracle Database

If your application is not using any TZ related code, then 9i would not need to 
be patched/upgraded.

If you are using Java Stored Procedures then JVM would need to be 
patched/upgraded irrespective of 9i/10g.

HTH

GovindanK
On Mon, 22 Jan 2007 16:38:49 -0500, "Fedock, John (KAM.RHQ)" 
<John.Fedock@xxxxxxxxxxxx> said:

I have spent the afternoon reviewing the DST issues (database and JVM) that 
take affect in March.


After looking at MetaLink notes 359145.1, 396387.1, 396671.1, 397281.1, 
402742.1, 396906.1, 396670.1 and 397013.1, my head is spinning.  Each note 
refers to 3 other notes and so on and so on.


I have many databases from 9.2.x thru 10.2.x, all on Windows.


How are others handling?  Can anyone summarize in less than 2 pages?





John Fedock

"K" Line America, ISD Department

Other related posts: