Creating a workspace manually

Before a developer can do something in APEX, he/she needs to have a workspace. The workspace is linked to a schema. In this recipe, you will be creating a workspace manually and assigning a schema to it.

Getting ready

Before you can implement this recipe, you need to have access to the internal workspace. The internal workspace is a special workspace where the APEX administration applications reside. There is one user created already and that is the admin user.

There are two ways to start the APEX administration:

1. Go to http://yourhost:port/apex/apex_admin and log in using the admin login credentials. Use the link in the lower-left corner of the login page (Administration).

2. Go to http://yourhost:port/apex and log in as admin on the internal workspace.

   

The password can be set using the apxxepwd.sql script. You can find this script in the APEX directory, that is, in Oracle home of the RDBMS installation or in the downloaded ZIP file of APEX. It is the same directory...