Managing Workspace to Schema Assignments

Viewing the Existing Schema and Workspace Assignment

Oracle Application Express administrators can view the existing schema to workspace assignment on the Manage Workspace to Schema Assignments page.

To view the existing schema to workspace assignment:

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

2. Click Manage Workspaces.

3. Under Manage Workspaces, click Manage Workspace to Schema Assignments.

   The Manage Workspace to Schema Assignments page appears. It lists all workspaces in your environment along with its most recently associated schema. Note that only one schema appears for each workspace in this list.

Editing an Existing Schema and Workspace Assignment

To edit an existing schema and workspace assignment:

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

2. Click Manage Workspaces.

3. Under Manage Workspaces, click Manage Workspace to Schema Assignments.

   The Manage Workspace to Schema Assignments page appears.

4. To edit an existing workspace to schema assignment:

   1. Select the workspace name.

      The Edit Schema to Workspace Assignment page appears.

   2. Select a new workspace or schema.

   3. Click Apply Changes.

Associating Additional Schemas to a Workspace

Oracle Application Express administrators can associate additional existing schemas to a workspace.

To associate additional schemas to a workspace:

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

2. Click Manage Workspaces.

3. Under Manage Workspaces, click Manage Workspace to Schema Assignments.

   The Manage Workspace to Schema Assignments page appears.

4. Click Create.

   The Add Schema wizard appears.

5. For New or Existing Schema, select Existing and click Next.

6. Follow the on-screen instructions to associate the existing schema to a workspace.

7. To verify that the new schema is added to the workspace:

   1. Log in to the workspace on Oracle Application Express.

   2. Review the Workspace Schemas list on the Workspace home page. The list shows all schemas currently associated with this workspace.

Creating a New Schema

Oracle Application Express administrators can create a new schema and associate it with a workspace.

To create a new schema for a workspace:

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

2. Click Manage Workspaces.

3. Under Manage Workspaces, click Manage Workspace to Schema Assignments.

   The Manage Workspace to Schema Assignments page appears.

4. Click Create.

   The Add Schema wizard appears.

5. For New or Existing Schema, select New and click Next.

6. For Choose Workspace, select the workspace that you want to associate the new schema with and click Next.

7. For Identify Schema:

   1. Schema - Enter a unique name containing only letters.

      
      

      Tip: To verify that the new schema name is unique, open the select list and search for the name.

      
      

   2. Password - Enter a case-sensitive password.

   3. Default Tablespace - Identify the default tablespace that you want this schema to use.

   4. Temporary Tablespace - Identify the temporary tablespace you want this schema to use.

   5. Click Next.

8. Confirm the information and click Add Schema.

9. To verify that the new schema is added to the workspace:

   1. Log in to the workspace on Oracle Application Express.

   2. Review the Workspace Schemas list on the Workspace home page. The list shows all schemas associated with this workspace.