Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_WM , 51 of 52
This procedure enables changes to a workspace, reversing the effect of FreezeWorkspace Procedure.
DBMS_WM.UnfreezeWorkspace( workspace IN VARCHAR2);
Parameter | Description |
---|---|
workspace |
Name of the workspace. The name is case sensitive. |
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.
The following example unfreezes the NEWWORKSPACE
workspace.
EXECUTE DBMS_WM.FreezeWorkspace ('NEWWORKSPACE');
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|