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

(re-sending to avoid quoted-printable characters) Mladen, look at the text of the error message in 10.1. Perhaps you had no tables containing a column with datatype TIMESTAMP WITH LOCAL TIME ZONE?

9.2 database
SQL> select count (*) from dba_tab_columns   2 where data_type like 'TIMESTAMP%WITH LOCAL TIME ZONE' ;  COUNT(*)

        0
SQL> alter database set time_zone = 'PST'; Base de données modifiée.

SQL> create table t (twltz timestamp with local time zone) ; Table créée.
SQL> select count (*) from dba_tab_columns   2 where data_type like 'TIMESTAMP%WITH LOCAL TIME ZONE' ;

 COUNT(*)

        1
SQL> alter database set time_zone = 'PST'; alter database set time_zone = 'PST'
*
ERREUR à la ligne 1 :
ORA-02231: missing or invalid option to ALTER DATABASE

-----Original Message-----
Mladen Gogala
>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>

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