RollbackWorkspace Procedure

This procedure discards all changes made in the workspace to all tables.

Syntax

DBMS_WM.RollbackWorkspace(
   workspace       IN VARCHAR2
   [, auto_commit  IN BOOLEAN DEFAULT TRUE]);

Parameters

Table 70-35 RollbackWorkspace Procedure Parameters  

Parameter	Description
workspace	Name of the workspace. The name is case sensitive.
auto_ commit	A boolean value (TRUE or FALSE). TRUE (the default) causes the operation to be executed as an autonomous regular transaction that will be committed when it finishes. FALSE causes the operation to be executed as part of the caller's open regular transaction (if one exists). If there is no open regular transaction, the operation is executed in a new regular transaction. In either case, the caller is responsible for committing the transaction.

Usage Notes

Only leaf workspaces can be rolled back. That is, a workspace cannot be rolled back if it has any descendant workspaces. (For an explanation of workspace hierarchy, see Oracle9i Application Developer's Guide - Workspace Manager.)

Contrast this procedure with RollbackToSP Procedure, which rolls back changes to a specified savepoint.

Like RemoveWorkspace Procedure, RollbackWorkspace deletes the data in the workspace; however, unlike RemoveWorkspace Procedure, RollbackWorkspace does not delete the Workspace Manager workspace structure.

While this procedure is executing, the specified workspace is frozen in NO_ACCESS mode.

An exception is raised if one or more of the following apply:

• workspace has any descendant workspaces.

• workspace does not exist.

• You do not have the privilege to roll back workspace or any affected table.

• Any sessions are active in workspace.

Examples

The following example rolls back any changes made in the NEWWORKSPACE workspace since that workspace was created.

EXECUTE DBMS_WM.RollbackWorkspace ('NEWWORKSPACE');