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