1.4 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.

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.

  • Requesting a New Schema
    Request a new schema by making a service request and selecting Request Schema.
  • Requesting More Storage
    Request more storage for a workspace by making a service request and selecting Request Storage.
  • Terminating a Workspace
    Terminate a workspace by making a service request and selecting Request Termination.
  • Determining the Amount of Space Available in Your Workspace
    Workspace administrators can use the Detailed Tablespace Utilization report to see the amount of free space available in a workspace. Viewing this report prior to requesting additional storage, enables administrators to determine how much additional storage space they need.
  • Signing Up for Another Workspace
    Sign up for another workspace by making a service request and selecting Sign up for another workspace.

See Also:

"Managing Workspace and Change Requests"

1.4.1 Requesting a New Schema

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

A schema is 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.

1.4.2 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.

1.4.3 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.

1.4.4 Determining the Amount of Space Available in Your Workspace

Workspace administrators can use the Detailed Tablespace Utilization report to see the amount of free space available in a workspace. Viewing this report prior to requesting additional storage, enables administrators to determine how much additional storage space they need.

See Also::

Requesting More Storage

1.4.4.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.

1.4.5 Signing Up for Another Workspace

Sign up for another workspace by making a service request and selecting Sign up for another workspace.

To request another 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 Sign up for another workspace.
  5. Follow the online registration instructions.

See Also:

"Requesting a New Workspace Manually"