FreezeWorkspace Procedure

This procedure disables changes in a workspace and prevents subsequent sessions from entering the workspace.

Syntax

DBMS_WM.FreezeWorkspace(
   workspace        IN VARCHAR2
   [, freezemode    IN VARCHAR2 DEFAULT 'NO_ACCESS']
   [, freezewriter  IN VARCHAR2 DEFAULT NULL] 
   [, force         IN BOOLEAN DEFAULT FALSE]);

Parameters

Table 70-14 FreezeWorkspace Procedure Parameters  

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: NO_ACCESS: No sessions are allowed in the workspace. (This is the default.) READ_ONLY: Sessions are allowed in the workspace, but no write operations (insert, update, delete) are allowed. 1WRITER: Sessions are allowed in the workspace, but only one user (see the freezewriter parameter) is allowed to perform write operations (insert, update, delete). WM_ONLY: Only Workspace Manager operations are permitted. No sessions can directly modify data values or perform queries involving table data; however, child workspaces can be merged into the workspace, and savepoints can be created in the workspace.
freezewriter	The user that is allowed to make changes in the workspace. Can be specified only if freezemode is 1WRITER. The default is USER (the current user).
force	A boolean value (TRUE or FALSE). TRUE forces the workspace to be frozen even if it is already frozen. For example, this value lets you freeze the workspace with a different freezemode parameter value without having first to call the UnfreezeWorkspace Procedure. FALSE (the default) prevents the workspace from being frozen if it is already frozen.

Usage Notes

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.

Examples

The following example freezes the NEWWORKSPACE workspace.

EXECUTE DBMS_WM.FreezeWorkspace ('NEWWORKSPACE');