Re: Oracle and DST changes
- From: "GovindanK" <gkatteri@xxxxxxxxxxx>
- To: John.Fedock@xxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Mon, 22 Jan 2007 15:02:39 -0800
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:
