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:

• SetWMValidTimeFilterON and SetWMValidTimeFilterOFF set and remove a valid time filter for the current session. A valid time filter is a time that is applied to queries against version-enabled tables that have valid time support. When a valid time filter is set for the current session, only rows that are valid for the specified time are returned.

• SetWMValidUpdateModeON and SetWMValidUpdateModeOFF enable and disable sequenced update and delete operations on tables that have valid time support.

These procedures are documented in Chapter 4.

MP_ROOT_WORKSPACE Column in xxx_WORKSPACES Views

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.

DBA_WM_VT_ERRORS View

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.