Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ALERT - Potentially Serious Problem with DST Patches for PST8PDT Timezone

RE: ALERT - Potentially Serious Problem with DST Patches for PST8PDT Timezone

From: Malpass, Nancy <>
Date: Thu, 1 Feb 2007 13:39:55 -0600
Message-ID: <7666881061F0C34BAC4EF37E856883F0D572B0@ad01msxmb014.US.Cingular.Net>

I attended the DST patch webcast and asked about this - you can just add the PST8PDT to the CSV file before you check your data but Allen is correct there will be a note appearing shortly on Metalink. I once asked when I found and documented a bug in Oracle (8.1.5) if there was some sort of $$ associated with discovering this bug - Nope but thanks for heads up Allen.

[] On Behalf Of Mercadante, Thomas F (LABOR)
Sent: Thursday, February 01, 2007 7:09 AM To:; oracle-l-freelists Subject: RE: ALERT - Potentially Serious Problem with DST Patches for PST8PDT Timezone

I don't know about anyone else.

But I'm shocked that something like this could happen. Oracle *always* tests everything that they release.

You must have done something wrong Allen.

This transmission may contain confidential, proprietary, or privileged information which is intended solely for use by the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, copying or distribution of this transmission or its attachments is strictly prohibited. In addition, unauthorized access to this transmission may violate federal or State law, including the Electronic Communications Privacy Act of 1985. If you have received this transmission in error, please notify the sender immediately by return e-mail and delete the transmission and its attachments.

[] On Behalf Of Allen, Brandon Sent: Wednesday, January 31, 2007 3:35 PM To: oracle-l-freelists
Subject: ALERT - Potentially Serious Problem with DST Patches for PST8PDT Timezone

Oracle-l list,

I just got confirmation from Oracle Support of a new problem I found with the timezone patches. I've been told a note/alert will be released on Metalink within a few days once they've worked out the details, but here is what I think I know so far:

DISCLAIMER: This is for informational purposes only - act on it at your own risk. I recommend waiting for official instructions from Oracle before taking any action.

In the v3 and v4 timezone files that have been released recently, the PST8PDT timezone has been added as a "real" timezone as opposed to just an alias for another timezone as it was in v2. This means that Oracle stores the internal timezone ID differently. The timezdif.csv files that were shipped with the updated utltzuv2.sql scripts erroneously omitted PST8PDT and the other v2 aliased timezones in the list of affected timezones to check for. The net result is that if you have any TSTZ data with the PST8PDT timezone or any of the other newly added v3 timezones*, then you need to back it up (copy to varchar2 column) before installing the new timezone files and then restore afterwards and this is regardless of the timeframe.

I haven't done any testing yet to find out exactly what happens with these timezones if you don't backup/restore them before & after the patch, but I plan to do that soon and will post my findings. I will also post an update with the Metalink note number as soon as they tell me about it.



*New timezones added in v3:



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.

Received on Thu Feb 01 2007 - 13:39:55 CST

Original text of this message