When a user logs into the Oracle HTML DB they log in to a shared work area called a workspace. Each workspace is an area within the Oracle HTML DB development environment where multiple developers can create applications. Each workspace has a unique numeric ID and name. In order to make changes to their workspace, Workspace administrators submit change request to an Oracle HTML DB administrator. Only an Oracle HTML DB administrator can approve change requests or provision new workspaces.
Topics:
When an Oracle HTML DB administrator creates a new workspace with a new schema, a new tablespace and datafile are created for that schema. The datafile for the new tablespace is managed by Oracle-managed files if Oracle-managed files is enabled.
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 datafile for the any new tablespaces will be named according to the Oracle-managed files conventions and the placement of these files will be determined by the database initialization parameter DB_CREATE_FILE_DEST
.
If the Oracle-Managed Files is not enabled, the datafile will be created in the same directory as the first datafile of the tablespace in which Oracle HTML DB was installed.
See Also: Oracle Database Administrator's Guide for information about Oracle-managed files |
As an Oracle HTML DB administrator, you determine how the process of provisioning (or creating) a workspace works for your Oracle HTML DB development instance.
In manual provision mode, an Oracle HTML DB administrator creates new workspaces and notifies the Workspace administrator of the login information. In request provision mode, users request workspaces directly in a self-service fashion. In this scenario, users use a link on the login page to access a request form. After the workspace request has been granted, users are automatically e-mailed the appropriate login information.
To specify a provisioning mode:
Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".
Click Manage Service.
Select Manage Environment Settings.
Under Self Service, select a provisioning status:
Manual - Oracle HTML DB administrator manually creates new workspaces and notifies the Workspace administrator of the login information.
Request - Users request workspaces directly in a self-service fashion.
If you select Request in the previous step, enter a URL in Development Service URL (optional).
The value you enter will used in the e-mail when the request is approved. This setting defines the URL for the service. If this setting is not present, the URL will be derived from your environment.
Click Apply Changes.
Note: To enable users to request a workspace using a link on the login page, an Oracle HTML DB administrator must choose the provisioning status of Request as described in the previous procedure. If the provisioning status is set to Manual, no link will appear on the login page. |
Oracle HTML DB administrators can provision a workspace manually by running the Create Workspace Wizard.
To create a workspace manually:
Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".
Click Manage Workspaces.
Select Create Workspace.
The Create Workspace Wizard appears.
Specify a workspace name and description and click Next.Specify whether you are re-using an existing schema or creating a new one.
If you are using an existing schema:
Re-use existing schema, select Yes.
Select a schema from the list and click Next.
If you creating a new schema:
Re-use existing schema, select No.
Enter a schema name and password.x
Specify a space quota and click Next.
Specify a Workspace administrator by providing a username, password, and e-mail address. Click Next.
Confirm your selections and click Provision.
Oracle HTML DB administrators can view detailed information about a specific workspace by viewing the Workspace Utilization Report.
To view a workspace report:
Log in to Oracle HTML DB Administration Services. See "Logging in to Oracle HTML DB Administration Services".
Click Manage Workspaces.
Select Workspace Details.
Select a workspace from the list and click Go.
The Workspace Utilization Report appears. Table 22-1 describes the various sections of the Workspace Utilization Report.
Table 22-1 Workspace Utilization Report
Report | Description |
---|---|
Name |
Displays high level information about the current workspace. |
Schemas |
Displays the default tablespace associated with the workspace schema. |
Tablespace Utilization |
Displays the schema that utilizing space in a tablespace. |
Applications |
Lists all applications within the current workspace. |
Developers |
Lists all application developers within the current workspace. |
HTML DB Users |
Lists all defined users within the current workspace. |
Objects by Type |
Lists objects used in the current workspace. |
Change Requests |
Lists all change requests in an Oracle HTML DB development instance. See Also: "Managing Change Requests" |
User Activity |
Lists user activity by date. |
Developer Activity |
Lists developer activity by developer name and application. |