RE: DST Apology

Yes, and like everything it's easy when you know how... but it is complicated when every oracle version has it's own process. Even though I am safe in that I only have 10g dictionary data, I went through all the motions... and indeed am now putting in the version 4 files.  

Two notes:  

If you are pressed for time do version 3 to be on time, and to be out ahead of things like the scheduler which might begin using the affected times. However, putting version 4 out there now is going to save you from essentially double dipping for about the same pain. I'm doing them one at a time, so there is no preasure now, and I can put the 4's out there.... I found that most of the focus is on 3... e.g. oracle9 query for timezone version 4 installed. Other queries exist, but this is an example of something available for 3 that 'might' not be available for 4. I have an SR requesting it, so we shall see. (strictly speaking it is not necessary).  

IMPORTANT: I strongly suggest you heed Brandons advice, because going back and fixing your data after you are finished seems simple... but be forwarned of things like how much time it takes. The script itself warns you it is not quick. (so multiply that by your data). I ran it and it took forever, but I had no data, and had to prime the pump to get the script started. I know one other person who says it went quite quick for her, so buyer beware.  

Joel Patterson
Database Administrator
joel.patterson_at_crowley.com
x72546
904 727-2546

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Allen, Brandon
Sent: Tuesday, February 20, 2007 3:26 PM To: jkstill_at_gmail.com; Oracle-L Freelists Subject: RE: DST Apology  

It's okay, we still love you Jared ;-)  

But while we're on the subject (again), let me emphasize for the 42nd time that the "updated" utltzuv2.sql script as downloaded from Metalink is in fact *not* complete/correct. I have been trying to get this point across for weeks now (on this list, under the subject "ALERT - Potentially Serious Problem with DST Patches for New Timezones"), but I'm not sure how many people are listening. Metalink released two notes addressing this problem on Feb 12th and I strongly recommend everyone read them: 414590.1 & 414826.1.  

Regards,

Brandon  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still

You do however need to make certain that you use the correct utltzuv2.sql script for your database - it will need to be downloaded from MetaLink.

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.

--
http://www.freelists.org/webpage/oracle-l