Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_WM , 6 of 52
This procedure deletes explicit savepoints in a workspace and minimizes the Workspace Manager metadata structures for the workspace.
DBMS_WM.CompressWorkspace( workspace IN VARCHAR2 [, compress_view_wo_overwrite IN BOOLEAN DEFAULT FALSE] [, firstSP IN VARCHAR2 DEFAULT NULL [, secondSP IN VARCHAR2 DEFAULT NULL] ] [, auto_commit IN BOOLEAN DEFAULT TRUE]);
or
DBMS_WM.CompressWorkspace( workspace IN VARCHAR2 [, firstSP IN VARCHAR2 DEFAULT NULL [, secondSP IN VARCHAR2 DEFAULT NULL] ] [, auto_commit IN BOOLEAN DEFAULT TRUE]);
You can compress a workspace when the explicit savepoints (all or some of them) in the workspace are no longer needed. The compression operation is useful for the following reasons:
While this procedure is executing, the current workspace is frozen in READ_ONLY
mode.
A workspace cannot be compressed 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.
For information about VIEW_WO_OVERWRITE
and other history options, see the information about the EnableVersioning Procedure.
An exception is raised if the user does not have the privilege to access and merge changes in workspace
.
To compress a workspace and all its descendant workspaces, use the CompressWorkspaceTree Procedure.
The following example compresses NEWWORKSPACE
.
EXECUTE DBMS_WM.CompressWorkspace (`NEWWORKSPACE');
The following example compresses NEWWORKSPACE
, deleting all explicit savepoints between the creation of the workspace and the savepoint SP1
.
EXECUTE DBMS_WM.CompressWorkspace (`NEWWORKSPACE', 'SP1');
The following example compresses NEWWORKSPACE
, deleting the explicit savepoint SP1
and all explicit savepoints up to but not including SP2
.
EXECUTE DBMS_WM.CompressWorkspace (`NEWWORKSPACE', 'SP1', 'SP2');
The following example compresses B_focus_1
, accepts the default values for the firstSP
and secondSP
parameters (that is, deletes all explicit savepoints), and specifies FALSE
for the auto_commit
parameter.
EXECUTE DBMS_WM.CompressWorkspace ('B_focus_1', NULL, NULL, FALSE);
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|