Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 9490 invoked from network); 23 Jan 2007 10:54:37 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 23 Jan 2007 10:54:31 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2AB3D5B07BC; Tue, 23 Jan 2007 11:52:21 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26924-06-5; Tue, 23 Jan 2007 11:52:21 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EB20D5B07C6; Tue, 23 Jan 2007 11:52:19 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 23 Jan 2007 11:51:10 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8FCA45AFB57 for ; Tue, 23 Jan 2007 11:51:10 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26420-01-5 for ; Tue, 23 Jan 2007 11:51:10 -0500 (EST) Received: from NT15.oneneck.corp (dot092host.oneneck.net [63.226.42.92]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D4C985B0670 for ; Tue, 23 Jan 2007 11:51:07 -0500 (EST) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2826 Priority: normal Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C73F0E.D49C84E3" Subject: RE: Oracle and DST changes Date: Tue, 23 Jan 2007 09:52:13 -0700 Message-ID: <04DDF147ED3A0D42B48A48A18D574C45071FD35A@NT15.oneneck.corp> In-Reply-To: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Oracle and DST changes References: <1169512034.29600.1170674979@webmail.messagingengine.com> From: "Allen, Brandon" To: , , "Mark Strickland" , , X-archive-position: 44648 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: Brandon.Allen@OneNeck.com Precedence: normal Reply-to: Brandon.Allen@OneNeck.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at avenirtech.net ------_=_NextPart_001_01C73F0E.D49C84E3 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Tom, not sure if you saw this post yesterday, but Metalink 359145.1 seems to say that you do need to patch 10g even if you're not using the TZ data types: =20 "When any data, either in the dictionary or in the user data or in the usage of time zones in PL/SQL, uses the affected time zones, then the patch is needed." =20 I also checked my 10.2.0.2 dictionary and there are 149 columns using the TZ data types. Please let me know if I'm missing something though, because I'd rather not install the patch if I don't have to. =20 Thanks, Brandon =20 =20 ________________________________ From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Mercadante, Thomas F (LABOR) I also agree about not patching anything if I'm not using Time Zone data types. We only have one 10.2.0.2 database and I'm not too worried about it. 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. ------_=_NextPart_001_01C73F0E.D49C84E3 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Re: Oracle and DST changes
Tom, not = sure if you=20 saw this post yesterday, but Metalink 359145.1 seems = to say that you do = need to=20 patch 10g even if you're not using the TZ data=20 types:
 
"When=20 any data, either in the dictionary or in the = user data=20 or in the usage of time zones in PL/SQL, uses the = affected=20 time zones, then the patch is=20 needed."
 
I also = checked my=20 10.2.0.2 dictionary and there are 149 columns using the TZ data = types. =20 Please = let me know if=20 I'm missing something though, = because I'd=20 rather not install the patch if I don't have=20 to.
 
Thanks,
Brandon
 
 

From: oracle-l-bounce@freelists.org=20 [mailto:oracle-l-bounce@freelists.org] On Behalf Of Mercadante, = Thomas F=20 (LABOR)

I also agree = about not=20 patching anything if I’m not using Time Zone data types.  We = only have one=20 10.2.0.2 database and I’m not too worried about = it.

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.

 ------_=_NextPart_001_01C73F0E.D49C84E3-- -- http://www.freelists.org/webpage/oracle-l