|Oracle9i Application Developer's Guide - Workspace Manager
Release 1 (9.0.1)
Part Number A88806-01
See current version.
A workspace created from its parent workspace.
Differences in data values resulting from changes to rows in the child and parent workspace. Conflicts are detected at merge time and presented to the user in conflict views.
See also merging (a workspace).
The version in which the changes are currently being made.
A Workspace Manager lock mode that prevents any other user from changing a locked row.
See also locks.
A savepoint that is explicitly created. It can later be used to perform partial rollbacks in workspaces.
Causing the condition in which no changes can be made to data in version-enabled rows in a workspace, and access to the workspace is restricted.
A savepoint that is created automatically whenever a new workspace is created.
The name of the logical savepoint that refers to the latest version in the workspace.
See also savepoint.
The name of the topmost workspace in the workspace hierarchy.
See also workspace hierarchy.
Version locks provided by Workspace Manager, separate from locks provided by conventional Oracle short transactions. These locks are primarily intended to eliminate row conflicts between a parent workspace and a child workspace. Locking is enabled at a session level and is a session property independent of the workspace that the session is in. When locking is enabled for a session, it locks rows in all workspaces in which it participates.
Applying changes made in a workspace to its parent workspace.
A workspace from which another workspace (a child workspace) was created.
A set of privileges for Workspace Manager that are separate from standard Oracle database privileges. Workspace-level privileges (with names in the form xxx_WORKSPACE) that allow the user to affect a specified workspace. System-level privileges (with names in the form xxx_ANY_WORKSPACE) that allow the user to affect any workspace.
Deleting either all changes made in the workspace or all changes made after a savepoint (that is, an explicit savepoint).
A point in the workspace to which operations can be rolled back. It is analogous to a firewall, in that by creating a savepoint you can prevent any damage to the "other side" of the wall (that is, operations performed in the workspace before the savepoint was created).
A Workspace Manager lock mode that allows only users in the workspace in which the row was locked to modify the row.
See also locks.
Reversing the effect of a freeze operation.
See also freezing (a workspace).
A table in the database in which all rows in the table can now support multiple versions of data. The versioning infrastructure is not visible to the database end users. After a table has been version-enabled, users automatically see the correct version of the record in which they are interested.
A virtual environment that one or more users can share to make changes to the data in the database. Workspace management involves managing one or more workspaces that can be shared by many users.
The hierarchy of workspaces in the database. For example, a workspace can be a parent to one or more workspaces. By default, when a workspace is created, it is created from the topmost, or
LIVE, database workspace.
The ability of the database to hold different versions of the same record (that is, row) in one or more workspaces.