|Oracle® OLAP DML Reference
10g Release 1 (10.1)
Part Number B10339-02
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.
Note:Oracle OLAP does not warn you when you delete an object that has the same name as an existing object in another attached 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.
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.
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.
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.
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
population in the preceding statement would produce an error.