DROP DIMENSION

Syntax

Purpose

To remove the named dimension.

For information on materialized views and their use of dimensions, see Oracle8i Concepts. See also "CREATE DIMENSION".

Prerequisites

The dimension must be in your own schema or you must have the DROP ANY DIMENSION system privilege to use this statement.

Keywords and Parameters

schema	is the name of the schema in which the dimension is located. If you omit schema, Oracle assumes the dimension is in your own schema.
dimension	is the name of the dimension you want to drop. The dimension must already exist.
	This statement does not invalidate materialized views that use relationships specified in dimension. However, requests that have been rewritten by query rewrite may be invalidated, and subsequent operations on such views may execute more slowly.

Example

This example drops the TIME dimension:

DROP DIMENSION time;