Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_WM , 33 of 52
This procedure rolls back the data in the workspace and removes all support structures created for the workspace. The workspace ceases to exist.
DBMS_WM.RemoveWorkspace( workspace IN VARCHAR2 [, auto_commit IN BOOLEAN DEFAULT TRUE]);
The RemoveWorkspace operation can only be performed on leaf workspaces (the bottom-most workspaces in a branch in the hierarchy). For an explanation of database workspace hierarchy, see Oracle9i Application Developer's Guide - Workspace Manager.
There must be no other users in the workspace being removed.
An exception is raised if the user does not have the REMOVE_WORKSPACE
privilege for workspace
or the REMOVE_ANY_WORKSPACE
privilege.
The following example removes the NEWWORKSPACE
workspace.
EXECUTE DBMS_WM.RemoveWorkspace('NEWWORKSPACE');
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|