|Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)
Part Number A89852-02
DBMS_WM , 41 of 52
This procedure discards all changes made in the workspace to all tables.
Name of the workspace. The name is case sensitive.
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
An exception is raised if one or more of the following apply:
workspacehas any descendant workspaces.
workspacedoes not exist.
workspaceor any affected table.
The following example rolls back any changes made in the
NEWWORKSPACE workspace since that workspace was created.