RE: Oracle and DST changes
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: "Barbara Baker" <barb.baker@xxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 23 Jan 2007 12:02:22 -0700
I don't think 1 & 3 are contradictory. I think the key difference is
that #1 says if the dict columns do not use affected time zones, the
patch is not needed. #3 says if the dict columns do use the affected
time zones, then the patch is needed.
For a better explanation of affected time zones (and affected time
frames), see 402614.1.
Regards,
Brandon
________________________________
From: Barbara Baker [mailto:barb.baker@xxxxxxxxx]
Sent: Tuesday, January 23, 2007 11:34 AM
To: Allen, Brandon; oracle-l
Subject: Re: Oracle and DST changes
ok,here's the entire blurb from 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.
Is it just me, or does #1 contradict #3 ? ? ?
And what exactly is affected time zones. I thought it was an area of
the U.S. where the time zone change will occur. But #3 says "when data
. . . uses the affected time zones" I interpret this to mean when there
is some code using the TSTZ or TSLTZ.
I'm with Tom on this one. We have JVM installed, but no Java
procedures. I'm interpreting this to mean I don't need the patch.
This is about as clear as mud to me . . .
Barb
On 1/23/07, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx> wrote:
Tom, not sure if you saw this post yesterday, but Metalink
359145.1 seems to say that you do need to patch 10g even if you're not
using the TZ data types:
"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."
I also checked my 10.2.0.2 dictionary and there are 149 columns
using the TZ data types. Please let me know if I'm missing something
though, because I'd rather not install the patch if I don't have to.
Thanks,
Brandon
Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do not
consent to Internet email for messages of this kind. Opinions, conclusions and
other information in this message that do not relate to the official business
of this company shall be understood as neither given nor endorsed by it.
Other related posts:
