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.
DBMS_WM.GotoSavePoint( [savepoint_name IN VARCHAR2 DEFAULT 'LATEST']);
Parameter | Description |
---|---|
savepoint_name |
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 Savepoint1
.
EXECUTE DBMS_WM.GotoSavepoint ('Savepoint1');
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|