Re: Oracle and DST changes

For 9.x  Per Note 359145.1

In Oracle9 there is no automatic use of the TSTZ and TSLTZ types. Therefore 
there is only a small chance that the patch is needed:
1. If there are no user-defined TSTZ or TSLTZ columns in the database, and 
there is no time zone use in PL/SQL, then the time zone files are not used and 
the patch is not needed.
2. If TSTZ or TSLTZ types or the TZ_OFFSET function are used, but do not use 
the affected time zones, the patch is not needed.
3. If TSTZ or TSLTZ types or the TZ_OFFSET function are used, and use the 
affected time zones, then a patch is needed.

For 10.x Per Note 359145.1

In Oracle10 the data dictionary uses TSTZ types. Therefore it is more likely 
that affected data is used:
1. If no TSTZ or TSLTZ types are used outside of the data dictionary, and the 
TZ_OFFSET function is not used, and the dictionary TSTZ columns do not use the 
affected time zones, the patch is not needed.
2. If TSTZ or TSLTZ types or or the TZ_OFFSET function are used outside the 
dictionary, but do not use the affected time zones, and the dictionary TSTZ 
columns do not use the affected time zones either, the patch is not needed.
3. When any data, either in the dictionary or in the user data or in the usage 
of time zones in PL/SQL, uses the affected time zones, then the patch is needed.

If you  are using Oracle AS/Infrastructure db, don't miss 359145.1 , 329361.1 , 
397281.1 ,  359362.1 , 356201.1

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: