UnfreezeWorkspace Procedure

This procedure enables changes to a workspace, reversing the effect of FreezeWorkspace Procedure.

Syntax

DBMS_WM.UnfreezeWorkspace(
   workspace  IN VARCHAR2);

Parameters

Table 70-42 UnfreezeWorkspace Procedure Parameters  

Parameter	Description
workspace	Name of the workspace. The name is case sensitive.

Usage Notes

The operation fails if any sessions are active in workspace.

Only the owner of the workspace or a user with WM_ADMIN_ROLE can unfreeze a workspace. There are no specific privileges associated with freezing a workspace.

Examples

The following example unfreezes the NEWWORKSPACE workspace.

EXECUTE DBMS_WM.FreezeWorkspace ('NEWWORKSPACE');