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
16
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!