RE: [SPAM] - Re: How to get timezone in 9i - Bayesian Filter detected spam
- From: "Jacques Kilchoer" <Jacques.Kilchoer@xxxxxxxxx>
- To: <Oracle-L@xxxxxxxxxxxxx>
- Date: Tue, 22 Feb 2005 15:28:13 -0800
(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>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
