Users access Oracle Application Express by signing in to a shared work area called a workspace. An administrator can create workspaces manually or take advantage of an automated approach in which users click a link a login page.
See Also:
A workspace enables multiple users to work within the same Oracle Application Express 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:
"Making a Service Request" and "Managing Workspace and Change Requests"
The Instance administrator determines how the process of provisioning (or creating) a workspace works for a specific Oracle Application Express instance.
To determine how provisioning works, an Instance Administrator selects an option on the Instance Settings page:
Manual - An Instance administrator creates new workspaces and notifies the Workspace administrator of the login information.
Request - Users request workspaces directly in a self-service fashion. Users click a link on the login page to access a request form. After the workspace request has been granted, users are automatically emailed the appropriate login information.
Request with Email Verification -Users request workspaces directly by clicking a link on the login page to access a request form. Each user receives an initial email containing a verification link. When the user clicks the verification link, the request is processed. The user can then access the workspace using the Sign In page.
Note:
To enable users to request a workspace using a link on the Login page, you must choose the provisioning status of Request or Request with Email Verification. If the provisioning status is set to Manual, no link appears on the login page.
To determine how provisioning works, an Instance Administrator selects a provisioning mode.
To select a provisioning mode:
Tip:
If you select Request with Email Verification, you can disable workspace provisioning and send users a message. See "Disabling Email 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 Oracle Application Express is installed.
See Also:
"Using Oracle Managed Files" in Oracle Database Administrator's Guide
Instance administrators can provision a workspace manually in either a full development environment or a runtime environment.
Instance administrators can create workspaces manually in a full development environment by running the Create Workspace Wizard.
To create a workspace manually:
Instance administrators can create workspaces manually in a runtime environment starting SQL*Plus and running the following SQL statements.
To add a workspace in a runtime environment:
See Also:
"ADD_WORKSPACE Procedure" in Oracle Application Express API Reference