Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Huge data in outdated APEX installations in the cloud 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

Huge data in outdated APEX installations in the cloud database

Received Response
edited Nov 25, 2020 9:33PM in Oracle Cloud Infrastructure - General 1 comment


How to delete outdated APEX database users in an autonomous database?


Hey guys,

I have an issue with the size of my cloud database and couldn't find a solution for this so far. Sorry if I missed something obvious.

My database grew by many gigabytes lately, and I found that 2/3 of the AWR size is blocked by data from old apex versions with the database users APEX_190200 and APEX_200100.

In a non-cloud database I would DROP CASCADE those users after successful installation of APEX_200200 with SYSDBA rights. I tried the same with the ADMIN user of my autonomous cloud database, but am stopped by "insufficient privileges".

Howdy, Stranger!

Log In

To view full details, sign in.


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