Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_WM , 11 of 52
This procedure deletes a savepoint.
DBMS_WM.DeleteSavepoint( workspace IN VARCHAR2, savepoint_name IN VARCHAR2) [, compress_view_wo_overwrite IN BOOLEAN DEFAULT FALSE] [, auto_commit IN BOOLEAN DEFAULT TRUE]);
You can delete a savepoint when it is no longer needed (for example, you will not need to go to it or roll back to it).
Deleting a savepoint is useful for the following reasons:
To delete a savepoint, you must have the WM_ADMIN_ROLE
role or be the owner of the workspace or the savepoint.
This procedure cannot be executed if there are any sessions with an open regular transaction, or if any user has executed a GotoDate Procedure operation or a GotoSavepoint Procedure operation specifying a savepoint in the workspace.
An exception is raised if one or more of the following apply:
workspace
does not exist.
savepoint_name
does not exist.
The following example deletes a savepoint named Savepoint1
in the NEWWORKSPACE
workspace.
EXECUTE DBMS_WM.DeleteSavepoint ('NEWWORKSPACE', 'Savepoint1');
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|