You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Can i drop the "APEX_050100" user in my DB to change TIME_ZONE?

edited Mar 14, 2018 7:00AM in Database 4 comments

Summary

Can i drop the "APEX_050100" user in my DB to change TIME_ZONE?

Content

Hello experts,

 

I'm using DBCS 11.2.0.4

 

Today i noticed that DB time zone is "+00:00".

We are in Cairo/Egypt so it should be "+02:00"

 

When i tried to alter using (alter database set TIME_ZONE = '+02:00';) it showed error:

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

 

Since i'm sure i'm not using this in my DB i issued this query to find where am i using this:

select owner, table_name

from   dba_tab_columns

where  data_type like 'TIMESTAMP%WITH LOCAL TIME ZONE';

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!