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

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


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