1 Reply Latest reply: Aug 1, 2013 5:06 AM by FreddieEssex RSS

    timezone upgrading


      Hi , I am going to upgrade my database from 10g to . After running utlu112i.sql I got recommendation to upgrade time as 4. Presently my timezone value is 3. Could you please help me in this regard. what patch I will use to upgrade timezone 4. OS AIX 6.1






        • 1. Re: timezone upgrading

          Presumably you mean upgrade to DST version 14?


          Check this Oracle Note for details - Actions For DST Updates When Upgrading To Or Applying The Patchset (Doc ID 1358166.1)

          See Section B.3b) When upgrading from 10.1.0.x , 10.2.0.x or 11.1.0.x to


          Also take a look at the following MOS Note:

          Updating the RDBMS DST version in 11g Release 2 ( and up) using DBMS_DST (Doc ID 977512.1)