RE: DST - its 20070215 and the patches are still in flux.

Yes, I did the version 3 thing, and I'm putting version 4 in now. The queries I found to check this on Oracle 9 return 0 with version 4 files... so I am looking for version 4 test queries that show version 4. I'm also looking for the client side files. Do you know where they are?    

Version 1, 2, 3 query for Oracle 9: Nothing for version 4.  

select case COUNT(DISTINCT(tzname))

         when 183 then 1

         when 355 then 1

         when 347 then 1

         when 377 then 2

         when 186 then

           case COUNT(tzname)

             when 636 then 2

             when 626 then 3

             else 0

           end

         when 185 then 3

         when 386 then 3

         when 387 then

           case COUNT(tzname)

             when 1438 then 3

             else 0

           end

         else 0

       end VERSION

  from v$timezone_names;  

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 Paul Drake Sent: Thursday, February 15, 2007 8:58 PM To: oracle-l
Subject: DST - its 20070215 and the patches are still in flux.  

I checked in on Note:397281.1 again today and found that Patch 5632264 has changed.
I don't get this.
Some people only get downtime windows once a month and have to test these patches out prior to applying them to production. So at what point is Oracle going to say "Ok. That's it. We're done. No more changes to DST patches. Go with it." Today is Feb 15th. The time change occurs on March 11th.

This act was passed in the year 2005.

The Canadian changes were not made in the calendar year 2005. Ok. I don't know when such changes were made. What I do know is that there is just over 3 weeks remaining until showtime and the script isn't written yet.

"The Canadian changes are only available in the the more recent
version-4. This version-4 of the time zone files is available through a one-off patch for bug 5632264
<http://updates.oracle.com/download/5632264.html> ,"

Granted:
"If you do not use any of the time zones that are updated in version-4
of the time zone files there is no need to specifically apply this, and you can just use version-3, which is more widely available at this moment."

I didn't take the course whereby I get to predict future usage patterns of an application.
So I guess that I take today's patch with version-4 time zones for 10.1.0.4 and run with it (and hope that it doesn't change again).

No version-5, please. No updates. Thanks.

Paul

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