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

Oracle Error Message

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

Reason for the Error

An attempt was made to alter database timezone with TIMESTAMP WITH LOCAL TIME ZONE column in the database.

Solution

Either do not alter database timezone or first drop all the TIMESTAMP WITH LOCAL TIME ZONE columns.