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.
DBMS_WM.RollbackWorkspace( workspace IN VARCHAR2 [, auto_commit IN BOOLEAN DEFAULT TRUE]);
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.
workspace
or any affected table.
workspace
.
The following example rolls back any changes made in the NEWWORKSPACE
workspace since that workspace was created.
EXECUTE DBMS_WM.RollbackWorkspace ('NEWWORKSPACE');
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|