Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle and DST changes

RE: Oracle and DST changes

From: Pabba, Chandra <Chandra.Pabba_at_fmr.com>
Date: Thu, 25 Jan 2007 15:48:50 -0600
Message-ID: <6D2375ACD32D9B48A9B433AA0527B084054A4972@MSGDCCCLA2WIN.DMN1.FMR.COM>


 Yes, I did notice the same thing. Without restarting the instance, I was able to see the updated results.

Thanks
Chandra

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Malpass, Nancy Sent: Thursday, January 25, 2007 3:45 PM To: joseph.armstrong-champ_at_tufts.edu; Brandon.Allen_at_OneNeck.com Cc: Mercadante, Thomas F (LABOR); oracle-l_at_freelists.org Subject: RE: Oracle and DST changes

That would be great to no have to restart each database. Anyone else do this and found that a restart is not necessary?

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Joe Armstrong-Champ Sent: Thursday, January 25, 2007 3:32 PM To: Brandon.Allen_at_OneNeck.com
Cc: Mercadante, Thomas F (LABOR); oracle-l_at_freelists.org Subject: Re: Oracle and DST changes

This actually turns out not to be true. I just applied the patch to a test db without shutting down and when I ran the confirmation sql I got the updated results:

SQL> select to_timestamp_tz('20070311 00:00:00 US/EASTERN','YYYYMMDD HH24:MI:SS TZR') + to_dsinterval('0 08:00:00') TEST from dual;

TEST


---
11-MAR-07 09.00.00.000000000 AM US/EASTERN

(solaris 64-bit/oracle 10.1.0.4)

Joe

Allen, Brandon wrote:
  It also confirms that the timezone files are in

> fact only read at startup, so a restart is necessary for the new rules

> to take effect.
>
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 25 2007 - 15:48:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US