Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Ora-30079

2776946May 17 2015 — edited May 17 2015

So i was tinkering and...

ALTER DATABASE SET TIME_ZONE = 'Europe/Zurich';

this gave me a 30079 error

*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.

Any reasons/insight into this?

Thanks

This post has been answered by aJohny on May 17 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 14 2015
Added on May 17 2015
2 comments
307 views