Re: [SPAM] - Re: How to get timezone in 9i - Bayesian Filter detected spam
- From: Mladen Gogala <mgogala@xxxxxxxxxxxxxxxxxxxx>
- To: Christian.Antognini@xxxxxxxxxxxx
- Date: Tue, 22 Feb 2005 15:36:39 -0500
Christian Antognini wrote:
>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...
>
>A) 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
>
>
>
I don't see what is the problem? It works in 9.2.0.5::
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
SQL> alter database set time_zone='EST';
Database altered.
SQL>
Are you sure that you're not trying to set TIMEZONE to STARDATE?
--
Mladen Gogala
Oracle DBA
Ext. 121
--
//www.freelists.org/webpage/oracle-l
Other related posts:
