|Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)
Part Number A89852-02
DBMS_WM , 40 of 52
This procedure discards all changes made after a specified savepoint in the workspace to all tables.
DBMS_WM.RollbackToSP( workspace IN VARCHAR2, savepoint_name IN VARCHAR2 [, auto_commit IN BOOLEAN DEFAULT TRUE]);
Name of the workspace. The name is case sensitive.
Name of the savepoint to which to roll back changes. The name is case sensitive.
While this procedure is executing, the workspace is frozen in
Contrast this procedure with RollbackWorkspace Procedure, which rolls back all changes made since the creation of the workspace.
You cannot roll back to a savepoint if any implicit savepoints have been created since the specified savepoint, unless you first merge or remove the descendant workspaces that caused the implicit savepoints to be created.
An exception is raised if one or more of the following apply:
workspacedoes not exist.
savepoint_namedoes not exist.
savepoint_name, and the descendant workspaces that caused the implicit savepoints to be created still exist.
workspaceor any affected table.
The following example rolls back any changes made in the
NEWWORKSPACE workspace to all tables since the creation of