ORA-30079: cannot alter database timezone when database has TIMESTAMP WITH LOCAL TIME ZONE columns

Hello,

Today when i try to change database time zone setting i got the below error message.


SQL> ALTER DATABASE SET TIME_ZONE = '+00:00';
ALTER DATABASE SET TIME_ZONE = '+00:00'
*
ERROR at line 1:
ORA-30079: cannot alter database timezone when database has TIMESTAMP WITH
LOCAL TIME ZONE columns

To avoid the above issues; follow the Document ID: 230099.1

Thanks, share with me your feedback/comments...