|Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)
Part Number A89852-02
DBMS_WM , 23 of 52
This procedure goes to the specified savepoint in the current workspace.
Name of the savepoint. The name is case sensitive. If
You are presented a read-only view of the workspace at the time of savepoint creation. This procedure is useful for examining the workspace from different savepoints before performing a rollback to a specific savepoint by calling RollbackToSP Procedure to delete all rows from that savepoint forward.
This operation can be executed while users exist in the workspace. There are no explicit privileges associated with this operation.
If you do not want to roll back to the savepoint, you can call GotoSavepoint with a null parameter to go to the currently active version in the workspace. (This achieves the same result as calling GotoWorkspace Procedure and specifying the workspace.)
For more information about savepoints, including the
LATEST savepoint, see Oracle9i Application Developer's Guide - Workspace Manager.
The following example goes to the savepoint named