3.11 Creating Workspaces in Administration Services
Users access Oracle APEX by signing in to a shared work area called a workspace. An administrator can create workspaces manually in Administration Services or take advantage of an automated approach in which users click a link a login page.
- About Workspaces
A workspace enables multiple users to work within the same APEX installation while keeping their objects, data and applications private. Each workspace has a unique numeric ID and name. - About Specifying How Workspaces Are Created
The Instance administrator determines how the process of provisioning (or creating) a workspace works for a specific APEX instance. - Selecting a Workspace Provisioning Mode
An Instance Administrator selects a Provisioning Method to determine how workspace provisioning works. - How Oracle-Managed Files Affects Workspace Provisioning
When an Instance administrator creates a new workspace with a new schema, a new tablespace and data file are created for that schema. If Oracle-Managed Files is enabled, it manages the data file for the new tablespace. - Creating a Workspace Manually
Instance administrators can provision a workspace manually in either a full development environment or a runtime environment. - Creating Multiple Workspaces
Provision multiple workspaces by running the Create Multiple Workspaces Wizard
See Also:
Parent topic: Oracle APEX Administration Services
3.11.1 About Workspaces
A workspace enables multiple users to work within the same APEX installation while keeping their objects, data and applications private. Each workspace has a unique numeric ID and name.
To make changes to a workspace, the Workspace administrators must submit a service or change requests to an Instance administrator. Only the Instance administrator can approve change requests or provision new workspaces.
See Also:
Parent topic: Creating Workspaces in Administration Services
3.11.2 About Specifying How Workspaces Are Created
The Instance administrator determines how the process of provisioning (or creating) a workspace works for a specific APEX instance.
To determine how provisioning works, an Instance Administrator selects a Provisioning Method on the Instance Settings page:
- Manual - An Instance administrator creates new workspaces and notifies the Workspace administrator regarding the Sign In credentials.
- Request - Users request a workspace. Once an administrator approves the request, the user receives an email containing an email verification link. After the user clicks the email verification link, the workspace is created.
- Automatic - Works similar to Request except requests are automatically approved with no administrator review required.
Note:
To enable users to request a workspace using a link on the Sign In page, the Instance administrator must choose either the Provisioning Method Request or Automatic and configure email. If the Provisioning Method is set to Manual, no link appears on the Sign In page.
About Request and Automatic Provisioning
If a workspace uses the Provisioning Methods Request or Automatic, the following events occur:
- The user receives an email containing an email verification link.
- When user clicks the verification link, the workspace is created.
- The user receives another email containing Sign In credentials (that is, the workspace name, username, and password).
- The status of the workspace request changes from
Accepted
toApproved
.
Parent topic: Creating Workspaces in Administration Services
3.11.3 Selecting a Workspace Provisioning Mode
An Instance Administrator selects a Provisioning Method to determine how workspace provisioning works.
Note:
To ensure the security and performance of your development environment, this functionality is not available in Oracle APEX instances running in Oracle Cloud.To select a Provisioning Method:
Tip:
If you select Automatic, you can disable workspace provisioning and send users a message. See Disabling Email Provisioning.
See Also:
Parent topic: Creating Workspaces in Administration Services
3.11.4 How Oracle-Managed Files Affects Workspace Provisioning
When an Instance administrator creates a new workspace with a new schema, a new tablespace and data file are created for that schema. If Oracle-Managed Files is enabled, it manages the data file for the new tablespace.
Using Oracle-managed files simplifies the administration of the Oracle database and eliminates the need for the database administrator (DBA) to directly manage the operating system files that comprise the database. Using Oracle-managed files, the DBA specifies operations in terms of database objects rather than file names. The data file for the new tablespaces are named according to the Oracle-managed files conventions. The placement of these files is determined by the database initialization parameter DB_CREATE_FILE_DEST
.
If the Oracle-Managed Files is not enabled, the data file is created in the same directory as the first data file of the tablespace in which APEX is installed.
See Also:
Using Oracle Managed Files in Oracle Database Administrator’s Guide
Parent topic: Creating Workspaces in Administration Services
3.11.5 Creating a Workspace Manually
Instance administrators can provision a workspace manually in either a full development environment or a runtime environment.
- Creating Workspace Manually in a Full Development Environment
Instance administrators can create workspaces manually in a full development environment by running the Create Workspace Wizard. - Creating a Workspace Manually in a Runtime Environment
Instance administrators can create workspaces manually in a runtime environment starting SQL*Plus and running the following SQL statements.
Parent topic: Creating Workspaces in Administration Services
3.11.5.1 Creating Workspace Manually in a Full Development Environment
Instance administrators can create workspaces manually in a full development environment by running the Create Workspace Wizard.
Note:
This topic does not apply to Oracle APEX instances running in Oracle Cloud. See the documentation for your Oracle Cloud service.To create a workspace manually:
Parent topic: Creating a Workspace Manually
3.11.5.2 Creating a Workspace Manually in a Runtime Environment
Instance administrators can create workspaces manually in a runtime environment starting SQL*Plus and running the following SQL statements.
Note:
To ensure the security and performance of your development environment, this functionality is not available in Oracle APEX instances running in Oracle Cloud.To add a workspace in a runtime environment:
See Also:
ADD_WORKSPACE Procedure in Oracle APEX API Reference
Parent topic: Creating a Workspace Manually
3.11.6 Creating Multiple Workspaces
Provision multiple workspaces by running the Create Multiple Workspaces Wizard
Note:
To ensure the security and performance of your development environment, this functionality is not available in Oracle APEX instances running in Oracle Cloud.To create multiple workspaces:
Parent topic: Creating Workspaces in Administration Services