My Oracle Support Banner

How to Remove the APEX Schema From a Multi-Tenant Database After a Failed Installation (Doc ID 2742795.1)

Last updated on FEBRUARY 09, 2023

Applies to:

Oracle Application Express (APEX) - Version 20.1 and later
Information in this document applies to any platform.

Goal

After a failed installation APEX, a part of the reinstall process is to remove the APEX schema. In the case of a 20.1 installation the schema is APEX_200100. In a standard database this is done using the following command:

DROP USER APEX_200100 CASCADE;

 

However in a multi-tenant database this command returns the following error:

SQL> drop user apex_200100 cascade;
drop user apex_200100 cascade
*
ERROR at line 1:
ORA-28014: cannot drop administrative users


How do you remove the APEX schema in multi-tenant database? 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.