|Oracle9i Application Developer's Guide - Workspace Manager
Release 2 (9.2)
Part Number A96628-01
This section describes new and changed Workspace Manager features for release 9.2.
Some DDL (data definition language) operations are supported on version-enabled tables and on indexes, triggers, and referential integrity constraints that refer to version-enabled tables, subject to guidelines and restrictions described in Section 1.6. The following new procedures related to DDL operations are documented in Chapter 2:
Workspace Manager supports replication of all workspace-related entities (such as workspaces and savepoints), operations (such as CreateWorkspace and MergeWorkspace), and DML and DDL operations on version-enabled tables. For information about using replication in a Workspace Manager environment, see Appendix C.
The following new procedures related to replication support are documented in Chapter 2:
The following new procedures are available for recovering version-enabled tables left in an inconsistent state after a failed upgrade procedure:
A synonym can be used instead of a table name for any
table_name input parameter, as explained in Section 1.9.
Multilevel referential integrity constraints are permitted on version-enabled tables, as explained in Section 1.7.
FREEZE_WORKSPACE privilege allows the user to freeze and unfreeze a specified workspace.
FREEZE_ANY_WORKSPACE privilege allows the user to freeze and unfreeze any workspace.
FREEZE_OWNERcontains the name of the user that froze the workspace.
YESif the workspace is frozen only for the duration of the current session;
NOif the workspace is frozen until an explicit UnfreezeWorkspace call is made; null if the workspace is not currently frozen.
YESif the current session is allowed to make changes in the workspace;
NOif the current session is not allowed to make changes in the workspace; null if the workspace is not currently frozen in
NO, indicating whether or not the savepoint can be rolled back to.
NO, indicating whether or not the savepoint is removable.
The following changes apply to the FreezeWorkspace procedure:
session_durationparameter. This parameter controls whether or not the workspace will be unfrozen when the session that called the FreezeWorkspace procedure disconnects from the database.
freezemodeparameter allows an additional value:
1WRITER_SESSION, which means that sessions are allowed in the workspace, but only the database session (as opposed to the database user) that called the FreezeWorkspace procedure is allowed to perform write operations (insert, update, delete). The workspace is unfrozen after the session that called the FreezeWorkspace procedure disconnects from the database.
The following changes apply to parameters of the CompressWorkspace procedure:
LATESTis now an acceptable value.
secondspparameters, all implicit savepoints that do not have any child workspace dependencies are also deleted.