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

1. Sign in to Oracle APEX 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.

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

1. Start SQLcl and connect to the database where Oracle APEX is installed as SYS, for example:

   • On Windows:

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

   • On UNIX and Linux:

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

2. Run the following statement:

   ALTER SESSION SET CURRENT_SCHEMA = APEX_240100
   

3. Run the following statement:

   SELECT APEX_INSTANCE_ADMIN.GET_SCHEMAS(WORKSPACE_NAME) 
   FROM DUAL;
   

   Where WORKSPACE_NAME is the name of the workspace.

Edit existing schema and workspace assignments.

1. Sign in to 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.

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

1. Sign in to 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 - Identify if the schema to be provisioned for the workspace exists or is new.
   1. Select Existing or New.
   2. Click Next.
   The UI changes depending upon your selection.
6. If The schema is a is Existing:
   1. Workspace - Enter the name of the workspace, or select one from the list.
   2. Click Next.
   3. Schema - Enter new schema name.
   4. Grant APEX Privileges - Leave Grant APEX Privileges on to grant all privileges needed by APEX to the schema.
   5. Click Next.
7. If The schema is a is New:
   1. Workspace - Enter the name of the workspace, or select one from the list.
   2. Click Next.
   3. Schema - Enter new schema name.
   4. Password - Enter a password for schema.
   5. Default Tablespace - Enter the default tablespace for the provisioned schema, or select one from the list.
   6. Temporary Tablespace - Enter the temporary tablespace for the provisioned schema, or select one from the list.
   7. Grant APEX Privileges - Leave Grant APEX Privileges on to grant all privileges needed by APEX to the schema.
   8. Click Next.
8. Review your selections and click Add Schema.

Associate additional schemas with a workspace in a runtime environment.

1. Start SQLcl and connect to the database where Oracle APEX is installed as SYS, for example:

   • On Windows:

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

   • On UNIX and Linux:

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

2. Run the following statement:

   ALTER SESSION SET CURRENT_SCHEMA = APEX_240100
   

3. Run the following statement:

   BEGIN
   APEX_INSTANCE_ADMIN.ADD_SCHEMA(WORKSPACE_NAME, SCHEMA_NAME, 'Y') END;

   Where:

   • WORKSPACE_NAME is the name of the workspace.

   • SCHEMA_NAME is the name of the schema.

   • 'Y' grants privileges needed by APEX to the schema. 'N' is the default.

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

1. Start SQLcl and connect to the database where Oracle APEX is installed as SYS, for example:

   • On Windows:

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

   • On UNIX and Linux:

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

2. Run the following statement:

   ALTER SESSION SET CURRENT_SCHEMA = APEX_240100
   

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.