I recently installed Oracle Database Express Edition 11g Release 2 (with APEX installed). Then went through the documented processes to upgrade APEX to R4.2. When I did that, I lost access to the APEX based GUI for managing the R11g XE database.
The "lost" application was reached by the URL http://127.0.0.1:8080/apex/f?p=4950
which now returns: Error Error processing request.
ORA-01403: no data found
Does anyone know if it is possible to recover or re-install the original Oracle Database Express Edition 11g Release 2 "Getting Started" APEX application in this new APEX 4.2 environment? This would greatly speedup my DB management tasks so I don't have to find SQL statements for all DB operations.
It's not part of Apex, it's a specific/separate application with XE.
You are not the first. You might want to search the forums for previous discussions/ideas on the topic.
But as suggested, use SQL Developer. The current versions has added a couple DBA tools, and you could also use its sql script capabilities to save and have a set of scripts ready.
Having your own set of queries/statements for "db operations" should be part of the survival kit anyway.