Skip Headers

Oracle® OLAP DML Reference
10g Release 1 (10.1)

Part Number B10339-02
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page

Go to previous page
Go to next page
View PDF


The DELETE command deletes one or more objects from a workspace. The deletion becomes permanent when you execute the UPDATE and COMMIT commands.


DELETE name... [AW workspace]



The names of one or more objects, separated by spaces or commas. DELETE removes the definitions of these objects from the appropriate workspace.

You can specify a qualified object name to indicate the attached workspace in which each object can be found. In this way, you can specify different workspaces for different objects that you are deleting. As an alternative, you can use the AW argument to specify the workspace in which all of the objects can be found. Do not use both qualified object names and the AW argument in the same DELETE command.

When you do not use a qualified object name or the AW argument to specify a workspace, objects are deleted in the current workspace.


Oracle OLAP does not warn you when you delete an object that has the same name as an existing object in another attached workspace.

AW workspace

The name of an attached workspace in which you wish to delete all the specified objects. When you do not use a qualified object name or the AW argument to specify a workspace, objects are deleted in the current workspace.


Deleting Associated Objects

To delete a dimension or a composite, you must first delete all the objects that are dimensioned by it and any objects that use it. Since a dimension surrogate cannot dimension other objects, you can delete a dimension surrogate at any time. Deleting a surrogate does not affect the dimension for which it is a surrogate.

Status of NAME

When you use the DELETE command when the NAME dimension is limited to less than all its values, DELETE automatically sets the status of NAME to ALL.

Renaming Before Deleting

When you see an error message when you try to delete an object, then the name of that object might be a reserved word. (Use RESERVED to identify reserved words.) When this is the case, use the RENAME command to give the object a new name, and then delete it.

Deleting and PERMIT

You cannot delete an object when a PERMIT command denies you the right to change its permission.


Example 10-32 Deleting a Dimension

Suppose you have a dimension named city and a variable named population that you want to delete. The variable population is the only object that is dimensioned by or makes use of city, so you can delete them both together when you place the variable before the dimension in the DELETE command.

DELETE population city

Placing city before population in the preceding statement would produce an error.