Skip to Main Content
Forums

Oracle Database Discussions

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!

how to check db time zone

sidAug 17 2011 — edited Aug 18 2011
Hello
Can anyone tell me the command to check database time zone and how to update it?

i tried SQL command
Alter database Set Time_Zone='Asia/Karachi'

But it gave the error
ORA-30079: cannot alter database timezone when database has TIMESTAMP WITH
LOCAL TIME ZONE columns

thanks and regards
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 15 2011
Added on Aug 17 2011
#general-database-discussions
25 comments
118,555 views