Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Unable to delete Old Version Apex Schema from ATP Database — Cloud Customer Connect
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

Unable to delete Old Version Apex Schema from ATP Database

Received Response
15
Views
4
Comments
edited Apr 16, 2022 7:22AM in Autonomous Database 4 comments

Summary

Unable to delete Old Version Apex Schema from ATP Database

Content

Hi,

I found that every time APEX is upgraded in ATP Database, the old apex schema is not deleted. It consumes SYSAUX tablespace storage, and in turn, it consumes the total available space. I use Always Free service which provides me with 20G storage space.

In my case, My Storage Usage is reported as 10Gigs, while my actual data is only about 0.002Gigs. I did query on table dba_segments and dba_free_space to find the information.

I saw schema APEX_190200, APEX_190100, which I don't use it anymore.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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