Re: DST Apology

Oracle keeps re-releasing the utltzuv2.sql scipt, on Windows. Today I found 5601428 for 10.2.0.2 again with new release date. No indication of version 4 files, could not figure out so quickly what else was changed. A bit strange is that the script requires jvm to be installed. If not then it will fail to complete succesfully (ORA-29538: Java not installed)

Regards,
Andre

2007/2/20, Joel.Patterson_at_crowley.com <Joel.Patterson_at_crowley.com>:
>
> 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