If you followed the guidelines of APEX 3.0 on XE, you have a working APEX 3.0 interface. However the administrative interface of APEX is not installed on XE by default. Using this interface you can manage all aspects of the service including creating, removing, and managing workspaces. Barney Mattox discovered a workaround to install this interface as well.
In order to install the administrative interface perform the following steps:
Start SQL*Plus. Make sure your working folder is the APEX installation folder (where
Connect as user
ALTER SESSION SET CURRENT_SCHEMA = FLOWS_030000
The following command imports the administrative interface:
- The following command imports the request for workspace interface:
Change the password for the
ADMINuser in order to login in the administrative interface:
Use the following URL to access the administrative interface
spool install.logafter logging in to SQL* Plus. If there occurs an error SQL*Plus will exit. You can use the logfile to find out what went wrong.
I experienced problems with step 3: Illegal security group id value for this schema. A workaround is to login as
FLOWS_030000and run the scripts. First you need to unlock user
ALTER USER FLOWS_030000 IDENTIFIED BY password ACCOUNT UNLOCK