3.15.5 Managing Workspace to Schema Assignments

Instance administrators can view, edit, and remove schema and workspace assignment, associate additional schemas with a workspace, and create new schemas.

When users sign in to Oracle Application Express, they access a shared work area called a workspace. Each workspace can have multiple associated (or mapped) schemas. By associating a workspace with a schema, developers in that workspace can create new database objects in that schema and build applications that interact with the database objects in that schema.

• Viewing Schema and Workspace Assignments in a Development Environment
  View an existing schema to workspace assignments in a full development environment.
• Viewing Schema and Workspace Assignments in a Runtime Environment
  View the existing schema to workspace assignments in a runtime environment.
• Editing Existing Schema and Workspace Assignments
  Edit existing schema and workspace assignments.
• Associating Schemas in a Full Development Environment
  Associate existing or new schemas with a workspace on the Manage Workspace to Schema Assignments page.
• Associating Additional Schemas in a Runtime Environment
  Associate additional schemas with a workspace in a runtime environment.
• Removing a Schema Mapping from a Workspace in a Runtime Environment
  Remove a schema mapping from a workspace in a runtime environment.

See Also:

"Managing Schemas" and "Viewing the Parsing Schemas Report"

3.15.5.1 Viewing Schema and Workspace Assignments in a Development Environment

View an existing schema to workspace assignments in a full development environment.

To view an existing schema to workspace assignment:

1. Sign in to Oracle Application Express Administration Services.
2. Click Manage Workspaces.
3. Under Workspace Actions, click Manage Workspace to Schema Assignments.

   The Manage Workspace to Schema Assignments page appears, listing all workspaces in your environment along with their associated schemas.

   This page displays as an interactive report. To customize the report, use the Search bar at the top of the page.

3.15.5.2 Viewing Schema and Workspace Assignments in a Runtime Environment

View the existing schema to workspace assignments in a runtime environment.

To view the existing schema to workspace assignment in a runtime environment:

1. Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS. For example:

   • On Windows:

     SYSTEM_DRIVE:\ sqlplus /nolog
     SQL> CONNECT SYS as SYSDBA
     Enter password: SYS_password
     

   • On UNIX and Linux:

     $ sqlplus /nolog
     SQL> CONNECT SYS as SYSDBA
     Enter password: SYS_password
     

2. Run the following statement:

   ALTER SESSION SET CURRENT_SCHEMA = APEX_190200
   

3. Run the following statement:

   SELECT APEX_INSTANCE_ADMIN.GET_SCHEMAS(WORKSPACE_NAME) 
   FROM DUAL;
   

   Where WORKSPACE_NAME is the name of the workspace.

3.15.5.3 Editing Existing Schema and Workspace Assignments

Edit existing schema and workspace assignments.

To edit an existing schema and workspace assignment:

1. Sign in to Oracle Application Express Administration Services.
2. Click Manage Workspaces.
3. Under Workspace Actions, 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.
   2. Select a new workspace or database schema.
   3. Click Apply Changes.

3.15.5.4 Associating Schemas in a Full Development Environment

Associate existing or new schemas with a workspace on the Manage Workspace to Schema Assignments page.

To associate a schemas with a workspace:

1. Sign in to Oracle Application Express Administration Services.
2. Click Manage Workspaces.
3. Under Workspace Actions, click Manage Workspace to Schema Assignments.
   The Manage Workspace to Schema Assignments page appears.
4. Click Add Schema.
   The Add Schema wizard appears.
5. The schema is a - Select Existing or New.
   The options that display next differ depending upon your selection.
6. If you select Existing:
   1. Workspace - Enter the name of the workspace, or select one from the list.
   2. Schema - Enter new schema name.
   3. Click Next.
7. If you select New:
   1. Workspace - Enter the name of the workspace, or select one from the list.
   2. Schema - Enter new schema name.
   3. Password - Enter a password for schema.
   4. Default Tablespace - Enter the default tablespace for the provisioned schema, or select one from the list.
   5. Temporary Tablespace - Enter the temporary tablespace for the provisioned schema, or select one from the list.
   6. Click Next.
8. Review your selections and click Add Schema.

3.15.5.5 Associating Additional Schemas in a Runtime Environment

Associate additional schemas with a workspace in a runtime environment.

To associate additional schemas with a workspace in a runtime environment:

1. Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS. For example:

   • On Windows:

     SYSTEM_DRIVE:\ sqlplus /nolog
     SQL> CONNECT SYS as SYSDBA
     Enter password: SYS_password
     

   • On UNIX and Linux:

     $ sqlplus /nolog
     SQL> CONNECT SYS as SYSDBA
     Enter password: SYS_password
     

2. Run the following statement:

   ALTER SESSION SET CURRENT_SCHEMA = APEX_190200
   

3. Run the following statement:

   BEGIN
   APEX_INSTANCE_ADMIN.ADD_SCHEMA(WORKSPACE_NAME, SCHEMA_NAME)
   END;
   

   Where:

   • WORKSPACE_NAME is the name of the workspace.

   • SCHEMA_NAME is the name of the schema.

3.15.5.6 Removing a Schema Mapping from a Workspace in a Runtime Environment

Remove a schema mapping from a workspace in a runtime environment.

To remove a schema mapping from a workspace in a runtime environment:

1. Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS. For example:

   • On Windows:

     SYSTEM_DRIVE:\ sqlplus /nolog
     SQL> CONNECT SYS as SYSDBA
     Enter password: SYS_password
     

   • On UNIX and Linux:

     $ sqlplus /nolog
     SQL> CONNECT SYS as SYSDBA
     Enter password: SYS_password
     

2. Run the following statement:

   ALTER SESSION SET CURRENT_SCHEMA = APEX_200100
   

3. Run the following statement:

   BEGIN
   APEX_INSTANCE_ADMIN.REMOVE_SCHEMA(WORKSPACE_NAME, SCHEMA_NAME)
   END;
   

   Where:

   • WORKSPACE_NAME is the name of the workspace.

   • SCHEMA_NAME is the name of the schema.