AW DELETE

The AW DELETE command deletes the specified workspace from the database. It is important to note that Oracle OLAP automatically executes a COMMIT as part of its procedure for deleting a workspace. The DELETE keyword executes successfully only when no user has the workspace attached.

Note:

When a program named TRIGGER_AW exists in the analytic workspace, the execution of an AW DELETE statement automatically executes that program.

See also:

AW DETACH, AW TRUNCATE

Syntax

AW DELETE workspace

Arguments

workspace: The name of the analytic workspace. You must specify the name; you cannot specify an alias.

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

Deleting a Workspace

You can use the AW command with the DELETE keyword to delete a workspace.

AW DELETE mywork