RE: [SPAM] Oracle and DST changes

My summary (and I hope it's correct, cause we have plans in place based on it) is:  

Do any of your databases use timezone aware datatypes, specifically TIMESTAMP WITH LOCAL TIMEZONE or TIMESTAMP WITH TIMEZONE?  

If the answer is no, or, for those databases where the answer is no, no worries, no patches need to be applied.  

Note that 10g uses timezone aware datatypes in the data dictionary in 10g (or so Oracle claims, I haven't gone looking for them), but as long as your app doesn't use the datatypes in question, you do not need to patch.  

If your app uses the datatypes in question, you need to patch. If you patch a server, all the timezone aware clients (9.2 and 10g) that connect to patched database must also be patched.    

Hope that helps,  

-Mark

--

Mark J. Bobak

Senior Oracle Architect

ProQuest Information & Learning

There is nothing so useless as doing efficiently that which shouldn't be done at all. -Peter F. Drucker, 1909-2005  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Fedock, John (KAM.RHQ)
Sent: Monday, January 22, 2007 4:39 PM
To: oracle-l_at_freelists.org
Subject: [SPAM] Oracle and DST changes
Importance: Low

I have spent the afternoon reviewing the DST issues (database and JVM) that take affect in March.  

After looking at MetaLink notes 359145.1, 396387.1, 396671.1, 397281.1, 402742.1, 396906.1, 396670.1 and 397013.1, my head is spinning. Each note refers to 3 other notes and so on and so on.  

I have many databases from 9.2.x thru 10.2.x, all on Windows.  

How are others handling? Can anyone summarize in less than 2 pages?        

John Fedock

"K" Line America, ISD Department  

--

http://www.freelists.org/webpage/oracle-l Received on Mon Jan 22 2007 - 16:08:41 CST