10 The APEX Workspaces Page


You can create and delete workspaces only if you have the APEX_Administrator_Role assigned.

You can create APEX workspaces using the APEX Workspaces page. For more information about APEX workspaces, see Workspace and Application Adminstration in the Oracle Application Express Administration Guide.

To navigate to this page, do either of the following:

  • In the Launchpad page, click APEX Workspaces.

  • Click Selector Selector icon to display the navigation menu. Under Administration, select APEX Workspaces.

For a specific workspace, you can perform the following actions using the Actions icon Actions context menu:

  • Create a Workspace: See Create a Workspace

  • Delete a Workspace: Removes the workspace and all associated applications from the database.

  • View Schema Details: Navigates to the Database Users page to view the related schema information.

10.1 Create a Workspace


You require Administrator privileges to create a workspace.

To create an APEX workspace:

  1. In the APEX Workspaces page, at the top right, click Create Workspace.
  2. Enter the following fields:
    • Workspace name: Enter a name for the workspace.

    • Database user: Select a schema from the drop-down list, or type to enter a new schema.

    • Workspace password: Enter a password for the workspace.

    • APEX Administrator: Enter the administrator user details.

    Show code: Select this option to view the PL/SQL code equivalent of the Create Workspace slider. You can copy and execute this PL/SQL code in the worksheet to perform the same action that occurs when you click Create in the Create Workspace slider.

  3. Click Create.

    The new workspace is displayed in the APEX workspaces page. The workspace card includes details such as the number of applications in the workspace, the number of developers using the workspace, and the number of administrators responsible for the workspace. Depending on your role, theActions iconActions context menu provides options such as creating and deleting a workspace, and viewing schema details.