What's New in Workspace Manager?

This section describes new and changed Workspace Manager features for Oracle Database 10g Release 2 (10.2).

where_clause Parameter and Subqueries

For all DBMS_WM procedures that accept a where_clause parameter, only primary key columns can be specified in the WHERE clause, except in a subquery. The subquery can refer to columns that are not primary keys, but it cannot refer to a version-enabled table.

In previous releases, the WHERE clause could contain only primary key columns, and and it could not contain a subquery.

The DBMS_WM functions and procedures are documented in Chapter 4.

New Valid Time Procedures

The following new DBMS_WM procedures are related to valid time support:

These procedures are documented in Chapter 4.


The ALL_WORKSPACES and USER_WORKSPACES views contain the new column MP_ROOT_WORKSPACE, which contains the name of the root workspace of the multiparent graph if the workspace is part of a multiparent graph.

These views are documented in Chapter 5.


The new DBA_WM_VT_ERRORS view contains information about the error that occurred during the last call to the DisableVersioning, CommitDDL, or RecoverFromDroppedUser procedure.

This view is documented in Chapter 5.

auto_commit Parameter Added to SetWorkspaceLockModeOn and SetWorkspaceLockModeOff Procedures

The SetWorkspaceLockModeON and SetWorkspaceLockModeOFF procedures now accept the auto_commit parameter.

These procedures are documented in Chapter 4.

Parameters Removed for SetValidTime Procedure

The SetValidTime procedure accepts only the validFrom and validTill parameters. The validFromFormat and validTillFormat parameters are no longer supported.

Dropping Users with Version-Enabled Tables

You can now drop database users that own one or more version-enabled tables. However, immediately after dropping any such users, you should call the new RecoverFromDroppedUser procedure, which is documented in Chapter 4.

DDL Operations and Table-Level Privileges

You can now grant table-level privileges on version-enabled tables to users, and you can revoke such privileges.

See Section 1.8 for information about DDL operations on version-enabled tables.