New and Changed Features

This section describes new and changed Workspace Manager features for release 9.2.

DDL Support Related to Version-Enabled Tables

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:

Replication Support for Workspace Manager

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 new WM_REPLICATION_INFO metadata view contains information about the Workspace Manager replication environment. This view is described in Chapter 3.

Migration Support Procedures

The following new procedures are available for recovering version-enabled tables left in an inconsistent state after a failed upgrade procedure:

These procedures are documented in Chapter 2. Migration (upgrade or downgrade) is described in Appendix B.

Session Context Information

Session context is a new concept, described in Section 1.2. You can retrieve session context information using the new GetSessionInfo procedure.

Synonym Support for Table Names

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 Support

Multilevel referential integrity constraints are permitted on version-enabled tables, as explained in Section 1.7.

New Privileges: FREEZE_WORKSPACE and FREEZE_ANY_WORKSPACE

The new FREEZE_WORKSPACE privilege allows the user to freeze and unfreeze a specified workspace.

The new FREEZE_ANY_WORKSPACE privilege allows the user to freeze and unfreeze any workspace.

WM_INSTALLATION View

The new WM_INSTALLATION metadata view contains information about the installed release of Workspace Manager. This view is described in Chapter 3.

STATE Column added to xxx_WM_VERSIONED_TABLES Views

A column named STATE is added to the ALL_WM_VERSIONED_TABLES and USER_WM_VERSIONED_TABLES metadata views. This column contains information about the state of each version-enabled table.

New Columns Added to xxx_WORKSPACES Views

The following columns are added to the ALL_WORKSPACES and USER_WORKSPACES metadata views:

FREEZE_OWNER contains the name of the user that froze the workspace.
SESSION_DURATION contains YES if the workspace is frozen only for the duration of the current session; NO if the workspace is frozen until an explicit UnfreezeWorkspace call is made; null if the workspace is not currently frozen.
CURRENT_SESSION contains YES if the current session is allowed to make changes in the workspace; NO if the current session is not allowed to make changes in the workspace; null if the workspace is not currently frozen in session_duration mode.

New Columns Added to xxx_WORKSPACE_SAVEPOINTS Views

The following columns are added to the ALL_WORKSPACE_SAVEPOINTS and USER_WORKSPACE_SAVEPOINTS metadata views:

CANROLLBACKTO contains YES or NO, indicating whether or not the savepoint can be rolled back to.
REMOVABLE contains YES or NO, indicating whether or not the savepoint is removable.

"Ignore Last Error" Option

The new ignore_last_error optional parameter for the DisableVersioning and CommitDDL procedures lets you ignore the last error from the previous call to the procedure.

Information about the last error is stored in the new ALL_WM_VT_ERRORS and USER_WM_VT_ERRORS metadata views.

FreezeWorkspace Options

The following changes apply to the FreezeWorkspace procedure:

An additional format includes the new session_duration parameter. This parameter controls whether or not the workspace will be unfrozen when the session that called the FreezeWorkspace procedure disconnects from the database.
The freezemode parameter 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.

See the reference information about the FreezeWorkspace procedure in Chapter 2.

CompressWorkspace Options and Behavior Changes

The following changes apply to parameters of the CompressWorkspace procedure:

For the firstsp parameter, LATEST is now an acceptable value.
For the firstsp and secondsp parameters, all implicit savepoints that do not have any child workspace dependencies are also deleted.

See the reference information about the CompressWorkspace procedure in Chapter 2 for more information.