Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- PrintPrint
APPENDIX Installing Oracle Application E... > Uninstalling Oracle APEX
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. For example, the following command drops the listed schemas (drop_apex.sql):
