![]() Previous |
![]() Next |
The AW DELETE command deletes a detached analytic workspace from the Database. It is important to note that Oracle OLAP automatically executes a COMMIT as part of its procedure for deleting an analytic workspace. The DELETE keyword executes successfully only when no user has the workspace attached.
Note: If the current analytic workspace is deleting a different analytic workspace and the current workspace contains a program named TRIGGER_AW, then the TRIGGER_AW program executes. |
Syntax
AW DELETE workspace
Parameters
The name of the analytic workspace. You must specify the name; you cannot specify an alias.
Usage Notes
Deleting an Unattached Workspace
When you attempt to delete an unattached workspace and the name is the same as an assigned alias, Oracle OLAP interprets the name as an alias and reports an error.
Examples