CWM2_OLAP_CUBE , 6 of 15

DROP_CUBE Procedure

This procedure drops a cube from the OLAP 2 Catalog.

Note:

When a cube is dropped, its associated measures are also dropped. However, the cube's dimensions are not dropped. They might be mapped within the context of a different cube.

Syntax

DROP_CUBE (
         cube_owner     IN   VARCHAR2,
         cube_name      IN   VARCHAR2);

Parameters

Table 17-6 DROP_CUBE Procedure Parameters

Parameter	Description
`cube_owner`	Owner of the cube.
`cube_name`	Name of the cube.

Exceptions

Table 17-7 DROP_CUBE Procedure Exceptions

Exception	Description
`no_access_privileges`	User does not have the necessary privileges. User must be the owner and have the `OLAP_DBA` role.
`cube_not_found`	Cube not found.