Oracle Database Discussions

Oracle Database 12.1.0.2

RHEL 6.4

Hello Team,

when changing the db timezone, I am getting error below

SQL> ALTER database SET TIME_ZONE = '+04:00';

ALTER database SET TIME_ZONE = '+04:00'

*

ERROR at line 1:

ORA-30079: cannot alter database timezone when database has TIMESTAMP WITH

LOCAL TIME ZONE columns

I have checked link below

DBA: Changing the Time Zone of the database (Oracle10g)

But I see 127 tables use the local timezone

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

  COUNT(*)

----------

       127

Is there any other way I can set the db timezone?

Thanks,

Joe