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

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-02231 error on ALTER DATABASE SET TIME_ZONE

Re: ORA-02231 error on ALTER DATABASE SET TIME_ZONE

From: Tanel Poder <tanel_at_@peldik.com>
Date: Sat, 22 Mar 2003 21:32:35 +0200
Message-ID: <3e7cb9b4$1_1@news.estpak.ee>


Bob,

Do you have any "timestamp with local timezone" datatypes in any of your tables in database?
Try to get rid of those objects before changing TZ before changing the TZ, if possible.

There are some bugs with this alter db set time_zone, which are to be fixed... in 10i :|

Tanel.

"Bob Aitchison" <raitchison_at_hotmail.com> wrote in message news:gl-dncjEdZLDNuGjXTWcqQ_at_comcast.com...
> I'm trying to set the database time zone for an Oracle 9.2 database
running
> under windows using the format:
>
> ALTER DATABASE SET TIME_ZONE= '+00:00';
>
> and I am continually getting error ORA-02231 missing or invalid option to
> alter database. I've tried other permutations (e.g., TIME_ZONE = 'GMT')
> with the same result and have been logged in as SYSDBA.
>
> Does anyone know what is causing this?
>
> Bob Aitchison
>
>
Received on Sat Mar 22 2003 - 13:32:35 CST

Original text of this message

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