Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-02231 error on ALTER DATABASE SET TIME_ZONE
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