ORA-30079
cannot alter database time zone when the database contains TIMESTAMP WITH LOCAL TIME ZONE columns
Cause
An attempt was made to alter the database time zone when there were tables containing TIMESTAMP WITH LOCAL TIME ZONE columns in the database.
Action
Do not alter the database time zone when there are tables containing TIMESTAMP WITH LOCAL TIME ZONE columns. Alternatively, export the tables containing TIMESTAMP WITH LOCAL TIME ZONE columns and drop them before altering the database. Finally, re-import the dropped tables.
ORA-30079
cannot alter database timezone when database has TIMESTAMP WITH LOCAL TIME ZONE columns
Cause
An attempt was made to alter database timezone with TIMESTAMP WITH LOCAL TIME ZONE column in the database.
Action
Either do not alter database timezone or first drop all the TIMESTAMP WITH LOCAL TIME ZONE columns.
ORA-30079
cannot alter database timezone when database has TIMESTAMP WITH LOCAL TIME ZONE columns
Cause
An attempt was made to alter database timezone with TIMESTAMP WITH LOCAL TIME ZONE column in the database.
Action
Either do not alter database timezone or first drop all the TIMESTAMP WITH LOCAL TIME ZONE columns.
