Oracle Database 11g Building Oracle XML DB Applications

Uninstalling Oracle APEX

You normally need to check the APEX-related database schemas before uninstalling Oracle APEX using the following command (check_apex_schema.sql):

COLUMN username FORMAT a25

COLUMN account_status FORMAT a30

SELECT username, account_status

FROM dba_users

WHERE username in(‘APEX_PUBLIC_USER’, ‘FLOWS_FILES’)

          or username like’APEX_%’ or username like ‘FLOWS_%’;

An example output is

USERNAME                     ACCOUNT STATUS

-------------------------------- ---------------------------------

APEX PUBLIC USER       OPEN

FLOWS FILES                   LOCKED

APEX 030200                     LOCKED

Export all the workspaces and applications created by Oracle APEX as a backup. Then drop the APEX-related database schemas. ...