I have downloaded Oracle 11g XE and installed it on my laptop,
Win 7 Enterprise
Everything works great, DB admin page comes up, APEX comes up (4.0.2.x).
I download the Apex_4.2.3_en.zip.
I extract the zip file and then follow the instructions in,
essentially the apexins.sql, apxldimg.sql with the admin password changes and anonymous user unlock.
This is the install command,
@apexins SYSAUX SYSAUX TEMP /i/
I get the
Error processing request
ORA-010403: no data found
The XE DB management GUI tools are not standard components of APEX, but special applications developed in APEX that are included in the default XE installation. As they are not part of the standard standalone APEX installation they are lost when you upgrade using this.
By upgrading to APEX 4.2 you have removed the database management GUI from XE. The only GUI admin tools provided by APEX are for managing the APEX instance and workspaces.
Backup and recovery and other basic DBA tasks must be performed using external tools like SQL*Plus and SQL Developer.
Use the Oracle Database Express Edition (XE) forum for XE database questions and this one for questions relating to application development in APEX.