Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle and DST changes

Re: Oracle and DST changes

From: GovindanK <gkatteri_at_fastmail.fm>
Date: Mon, 22 Jan 2007 23:02:39 UT
Message-Id: <1169506959.20191.1170663139@webmail.messagingengine.com>

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_at_us.kline.com> 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

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jan 22 2007 - 17:02:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US