Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_WM , 9 of 52
This procedure creates a savepoint for the current version.
DBMS_WM.CreateSavepoint( workspace IN VARCHAR2, savepoint_name IN VARCHAR2 [, description IN VARCHAR2 DEFAULT NULL] [, auto_commit IN BOOLEAN DEFAULT TRUE]);
There are no explicit privileges associated with savepoints; any user who can access a workspace can create a savepoint in the workspace.
This procedure can be performed while there are users in the workspace; a quiet point is not required.
While this procedure is executing, the current workspace is frozen in READ_ONLY
mode.
An exception is raised if one or more of the following apply:
workspace
does not exist.
savepoint_name
already exists.
The following example creates a savepoint named Savepoint1
in the NEWWORKSPACE
workspace.
EXECUTE DBMS_WM.CreateSavepoint ('NEWWORKSPACE', 'Savepoint1');
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|