RE: [SPAM] - Re: How to get timezone in 9i - Bayesian Filter detected spam

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Tue, 22 Feb 2005 21:23:11 +0100
Message-ID: <2CF83791A616BB4DA203FFD13007824A01E6B72A@MSXVS02.trivadis.com>

Hi

Carefully read this text...

>On Fri, 18 Feb 2005 16:42:34 +0100, Christian Antognini [snip]
>> Notice that you cannot alter the database if it stores tables with =
=3D
>> TIMESTAMP WITH LOCAL TIME ZONE columns.

And then give a look to these examples...

1. 9i

SQL> select * from v$version where rownum =3D 1;

BANNER

---

Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production

SQL> ALTER DATABASE SET TIME_ZONE =3D 'EST'; ALTER DATABASE SET TIME_ZONE =3D 'EST'
*
ERROR at line 1:
ORA-02231: missing or invalid option to ALTER DATABASE

B) 10g

SQL> select * from v$version where rownum =3D 1;

BANNER

---

Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Prod

SQL> ALTER DATABASE SET TIME_ZONE =3D 'EST'; ALTER DATABASE SET TIME_ZONE =3D 'EST'
*
ERROR at line 1:
ORA-30079: cannot alter database timezone when database has TIMESTAMP = WITH
LOCAL TIME ZONE columns

As you can see the error generated in 9i is completely wrong! They = recognized the problem and fixed it in 10g.

HTH
Chris

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Feb 22 2005 - 15:26:12 CST