Creating a Workspace Manually

Creating Workspace Manually in a Full Development Environment

Instance administrators can provision a workspace manually by running the Create Workspace Wizard.

To create a workspace manually:

1. Log in to Oracle Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".

2. Click Manage Workspaces.

3. Under Workspace Actions, click Create Workspace.

   The Create Workspace Wizard appears.

4. For Identify Workspace, enter the following:

   1. Workspace Name - Enter a unique workspace name.

   2. Workspace ID - Leave Workspace ID blank to have the new Workspace ID automatically generated. A Workspace ID must be a positive integer greater than 100000.

   3. Workspace Description - Enter a workspace description.

   4. Click Next.

5. For Identify Workspace, enter a workspace name and description and click Next.

6. For Identify Schema, specify whether you are re-using an existing schema or creating a new one.

   If you are using an existing schema:

   1. For Re-use existing schema, select Yes.

   2. Select a schema from the list.

   3. Click Next.

   If you are creating a new schema:

   1. For Re-use existing schema, select No.

   2. Enter a schema name and password.

   3. Specify a space quota.

   4. Click Next.

7. For Identify Administrator, enter the Workspace administrator information and click Next.

8. Confirm your selections and click Create Workspace.

Creating a Workspace Manually in a Runtime Environment

To add a workspace in a runtime environment:

1. Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS. For example:

   • On Windows:

     SYSTEM_DRIVE:\ sqlplus /nolog
     connect sys as sysdba
     

   • On UNIX and Linux:

     $ sqlplus /nolog
     connect sys as sysdba
     

   When prompted enter the appropriate password.

2. Run the following statement:

   ALTER SESSION SET CURRENT_SCHEMA = APEX_040000
   

3. Run the following statement:

   BEGIN
   APEX_INSTANCE_ADMIN.ADD_WORKSPACE(WORKSPACE_ID,WORKSPACE_NAME, SCHEMA_NAME, SCHEMA_LIST)
   END;
   

   Where:

   • WORKSPACE_ID is the ID for the workspace. Auto-assigned if NULL.

   • WORKSPACE_NAME is the name of the workspace.

   • SCHEMA_NAME is the name of the primary schema to associate with the workspace.

   • SCHEMA_LIST is a colon delimited list of additional schemas to associate with the workspace.