Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_WM , 14 of 52
This procedure disables changes in a workspace and prevents subsequent sessions from entering the workspace.
DBMS_WM.FreezeWorkspace( workspace IN VARCHAR2 [, freezemode IN VARCHAR2 DEFAULT 'NO_ACCESS'] [, freezewriter IN VARCHAR2 DEFAULT NULL] [, force IN BOOLEAN DEFAULT FALSE]);
Parameter | Description |
---|---|
workspace |
Name of the workspace. The name is case sensitive. |
freezemode |
Mode for the frozen workspace. Must be one of the following values:
|
freezewriter |
The user that is allowed to make changes in the workspace. Can be specified only if |
force |
A boolean value (
|
The operation fails if any sessions are active in workspace
(unless force
is TRUE
) and freezemode
is NO_ACCESS
.
If freezemode
is READ_ONLY
or 1WRITER
, the workspace cannot be frozen if there is an active regular transaction.
Only the owner of the workspace or a user with WM_ADMIN_ROLE
can freeze a workspace. There are no specific privileges associated with freezing a workspace.
The LIVE
workspace can be frozen only if freezemode
is READ_ONLY
or 1WRITER
.
To reverse the effect of FreezeWorkspace, use the UnfreezeWorkspace Procedure.
The following example freezes the NEWWORKSPACE
workspace.
EXECUTE DBMS_WM.FreezeWorkspace ('NEWWORKSPACE');
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|