2.3 Making a Service Request

Workspace administrators use the Request Service page to request a schema, add storage space, terminate a workspace, or request another workspace.

Note:

Service requests are only supported in Oracle Application Express on-premises.

Tip:

You can access many workspace administration functions (such as Manage Service, Make a Service Request) from both the Administration menu and the Workspace Administration home page. For consistency, this section navigates the user to the Workspace Administration home page.

See Also:

"Managing Requests"

2.3.1 Determining the Space Available in a Workspace

View the Detailed Tablespace Utilization report to determine the amount of free space available in a workspace. Oracle recommends viewing this report prior to requesting additional storage.

2.3.1.1 Viewing the Detailed Tablespace Utilization Report

Determine the amount of space available in a workspace by viewing the Detailed Tablespace Utilization Report.

To view the Detailed Tablespace Utilization report:

  1. Navigate to the Workspace Administration page:
    1. Sign in to Oracle Application Express.
    2. At the top of the Workspace home page, click the Administration menu and select Administration.

    The Workspace Administration home page appears.

  2. Click Manage Service.
  3. Click Make a Service Request.
  4. Click Detailed Tablespace Utilization Report (may take several seconds).

    A report appears displaying the tablespace name, available bytes, amount used, amount free, and percentage used.

2.3.2 Viewing the Service Request History for the Workspace

View the Service Request History report to determine the status of prior service requests in a workspace .

Workspace developers and administrators can view the Service Request History report prior to requesting additional storage to determine whether prior storage requests have been declined due to some underlying error.

To view the Service Request History report:

  1. Navigate to the Workspace Administration page:
    1. Sign in to Oracle Application Express.
    2. At the top of the Workspace home page, click the Administration menu and select Administration.

    The Workspace Administration home page appears.

  2. Click Manage Service.
  3. Click Make a Service Request.
  4. Expand Service Request History.

2.3.3 Requesting a New Schema

Request a new schema by making a service request and selecting Request Schema.

A schema is a named collection of database objects, including logical structures such as tables and indexes. A schema has the name of the database user who owns it.

To request a new schema:

  1. Navigate to the Workspace Administration page:
    1. Sign in to Oracle Application Express.
    2. At the top of the Workspace home page, click the Administration menu and select Administration.

    The Workspace Administration home page appears.

  2. Click Manage Service.
  3. Click Make a Service Request.
  4. Click Request Schema.
  5. On Request Database Schema, specify the following:
    1. Schema - Select either Request a new schema or Use an existing schema.
    2. Schema Name - Enter a new name or select one from the list.
    3. Click Next.
  6. Click Finish.

2.3.4 Requesting More Storage

Request more storage for a workspace by making a service request and selecting Request Storage.

To request more storage:

  1. Navigate to the Workspace Administration page:
    1. Sign in to Oracle Application Express.
    2. At the top of the Workspace home page, click the Administration menu and select Administration.

    The Workspace Administration home page appears.

  2. Click Manage Service.
  3. Click Make a Service Request.
  4. Click Request Storage.

    Tip:

    To see the amount of free space available in the workspace, click Detailed Tablespace Utilization Report (may take several seconds).

  5. On Request Storage, specify the following:
    1. Amount of Storage to Add - Select the amount of storage to add.
    2. Click Next.
  6. Confirm your request by clicking Request Storage.

2.3.5 Requesting Another Workspace

Request another workspace using a service request.

To request a new workspace using a service request:

  1. Navigate to the Workspace Administration page:
    1. Sign in to Oracle Application Express.
    2. At the top of the Workspace home page, click the Administration menu and select Administration.

    The Workspace Administration home page appears.

  2. Click Manage Service.
  3. Click Make a Service Request.
  4. Click Sign up for another workspace.
    The Request a Workspace Wizard appears.
  5. For Identification:
    1. First Name - Enter your first name.
    2. Last Name - Enter your last name.
    3. Email - Enter the email address. A link to activate your workspace will be sent to this email address.
    4. Workspace - Enter a workspace name that name uniquely identifies your development environment.
    5. Click Next.
  6. If defined, review and accept the service agreement and click Next.
  7. Verify your request and click Submit Request.

2.3.6 Terminating a Workspace

Terminate a workspace by making a service request and selecting Request Termination.

To terminate a workspace:

  1. Navigate to the Workspace Administration page:
    1. Sign in to Oracle Application Express.
    2. At the top of the Workspace home page, click the Administration menu and select Administration.

    The Workspace Administration home page appears.

  2. Click Manage Service.
  3. Click Make a Service Request.
  4. Click Request Termination.
  5. Confirm your request by clicking Next.