Cloud Platform

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!

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

GadoMar 13 2018 — edited Mar 14 2018

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';

Result:

APEX_050100 WWV_FLOW_WORKSHEET_NOTIFY

APEX_050100 APEX_PKG_APP_INSTALL_LOG

APEX_050100 WWV_FLOW_PKG_APP_INSTALL_LOG

OE ORDERS

APEX_050100 APEX$ARCHIVE_CONTENTS

APEX_050100 APEX$ARCHIVE_HEADER

APEX_050100 APEX$ARCHIVE_HISTORY

APEX_050100 APEX$ARCHIVE_LOG

APEX_050100 APEX$ARCHIVE_PREF

APEX_050100 APEX_APPLICATION_PAGE_IR_SUB

So what is APEX_050100 user exactly?

Can i drop it without breaking something?

Thank you

Gado

This post has been answered by Hany Ezzat -Oracle on Mar 13 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 11 2018

Added on Mar 13 2018

#database-cloud-service

3 comments

952 views