RE: Oracle and DST changes
- From: "Malpass, Nancy" <nancy.malpass@xxxxxxxxxxxx>
- To: <johan.muller@xxxxxxxxx>, "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- Date: Thu, 25 Jan 2007 10:34:49 -0600
What I have found on this topic so far is:
1.
DST patch is included in 10.2.0.3 patchset
2.
You should plan on patching your 10G databases because 10G
dictionary has TIMEZONE data types-can use 1-off
3.
You don't have to patch your clients if you are JDBC thin client
4.
If you have an application like a calender - that uses timezones
you will want to patch 9i
5.
You will want to patch 9i databases if you use the timezone data
types
6.
Prior to 9i these data types were not valid so - no need to
patch prior releases
7.
march 11th is the majic date when we start DST this year and
from now on
8.
If you don't patch the world will not end but you could see
strange time/date calcs and you would have to clean data after the patch
9.
there are many notes on metalink as was previously mentioned - i
have eaten thru several looking for what makes sense - there is a lot
to digest though.
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Johan Muller
Sent: Wednesday, January 24, 2007 2:01 PM
To: Allen, Brandon
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Oracle and DST changes
I forgot to add:
Put 'Daylight' into the the filter box to pull out the future scheduled
conferences.
On 1/24/07, Allen, Brandon < Brandon.Allen@xxxxxxxxxxx
<mailto:Brandon.Allen@xxxxxxxxxxx> > wrote:
Thanks for the tip!
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Johan Muller
Sent: Wednesday, January 24, 2007 12:06 PM
To: rajendra.pande@xxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Oracle and DST changes
This link for future presentations by Oracle could be of some
help; I missed the one scheduled for to-day.
https://conference.oracle.com/imtapp/app/wel_public_mtgs.uix?bajaPage=fi
lterField=MEETING_TITLE%24filterValue=%24gotoVal=1
On 1/24/07, Johan Muller <johan.muller@xxxxxxxxx> wrote:
Try this link - it gives a summary of the whole mess.
http://blogs.oracle.com/otn/stories/storyReader$367
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Pande, Rajendra
Sent: Wednesday, January 24, 2007 10:43 AM
To: mgogala@xxxxxxxxxxx; wjwagman@xxxxxxxxxxx
Cc: Thomas.Mercadante@xxxxxxxxxxxxxxxxx ;
gkatteri@xxxxxxxxxxx; Mark
Strickland; John.Fedock@xxxxxxxxxxxx;
oracle-l@xxxxxxxxxxxxx
Subject: RE: Oracle and DST changes
So how does that help..
Unless of course all you are dealing with are
databases,clients and data in
Arizona time zone. :)
Note that this DST change impacts the whole world as
soon as you are doing a
date calculation using US time zones. No matter where
you live.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:
oracle-l-bounce@xxxxxxxxxxxxx <mailto:oracle-l-bounce@xxxxxxxxxxxxx> ]
On Behalf Of Mladen Gogala
Sent: Wednesday, January 24, 2007 8:59 AM
To: wjwagman@xxxxxxxxxxx
Cc: Thomas.Mercadante@xxxxxxxxxxxxxxxxx;
gkatteri@xxxxxxxxxxx; Mark
Strickland; John.Fedock@xxxxxxxxxxxx;
oracle-l@xxxxxxxxxxxxx
Subject: Re: Oracle and DST changes
On 01/23/2007 11:52:37 AM, William Wagman wrote:
> Greetings,
>
> I have been looking at the Metalink notes and am not
clear I understand
> when it becomes necesary to upgrade the clients. If
one is only using
> the networking pieces of the clients and sqlplus is it
going to be
> necessary to upgrade the client in that case. I guess
the general
> question is, what client pieces will require the
upgrade?
>
You should move to Arizona, it doesn't have DST. It has
plenty of daylight
as it is, and
it is one of the few states that doesn't implement DST.
--
Mladen Gogala
http://www.mladen-gogala.com
--
//www.freelists.org/webpage/oracle-l
Please do not transmit orders or instructions regarding
a UBS account by
e-mail. The information provided in this e-mail or any
attachments is not an
official transaction confirmation or account statement.
For your protection,
do not include account numbers, Social Security numbers,
credit card
numbers, passwords or other non-public information in
your e-mail. Because
the information contained in this message may be
privileged, confidential,
proprietary or otherwise protected from disclosure,
please notify us
immediately by replying to this message and deleting it
from your computer
if you have received this communication in error. Thank
you.
UBS Financial Services Inc.
UBS International Inc.
--
//www.freelists.org/webpage/oracle-l
--
Johan Muller
Oracle DBA
(214) 676 2147 anytime.
"I love deadlines. I like the whooshing sound they make as they
fly by."
Douglas Adams
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.
--
Johan Muller
Oracle DBA
(214) 676 2147 anytime.
"I love deadlines. I like the whooshing sound they make as they fly by."
Douglas Adams
Other related posts:
