Loading ...
Sorry, an error occurred while loading the content.

ORA-1882 errors after time zone file patch

Expand Messages
  • Jim Hill
    If you have any data, including data in sys tables, that uses the data types WITH TIME ZONE and is in one of the follow time zones, it will have to be
    Message 1 of 1 , Feb 16, 2007
    • 0 Attachment
      If you have any data, including data in sys tables, that uses the data types WITH TIME ZONE and is in one of the follow time zones, it will have to be converted:  HST, EST, MST, EST5EDT, MST7MDT, CST6CDT, PST8PDT.  This is due to the fact that the time zone ID is different in the updated time zone files.  You will get ORA-1882's if you don't do the conversion.
       
      NOTE: This conversion will have to be done regardless of the time period that the data falls within.  See Note:414590.1

      Jim Hill <jfordhill@...> wrote:
      If you are doing Time Zone file upgrades on database servers, you will want to read this:
       
      Subject:Time Zone IDs for 7 Time Zones Changed in Time Zone Files Version 3 and Higher, Possible ORA-1882 After Upgrade
       Doc ID:Note:414590.1Type:BULLETIN
       Last Revision Date:15-FEB-2007
       
      For discussion on these topics you will need to sign up for the CAOUG-Discuss mailing list.  You can go to http://www.caoug.org/modules.php?op=modload&name=Mailing_Lists&file=index to add your email to the list.


      Need a quick answer? Get one in minutes from people who know. Ask your question on Yahoo! Answers.

    Your message has been successfully submitted and would be delivered to recipients shortly.