Oracle Cloud Infrastructure Documentation

Create an APEX Workspace

Note

  • This feature is available only for Oracle Autonomous Database or if Oracle REST Data Services is installed in the database.

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

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 user interface. 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, the Actions context menu provides options such as creating and deleting a workspace, and viewing schema details.