|Oracle® Database SQL Language Reference
11g Release 2 (11.2)
Part Number E17118-03
This statement does not invalidate materialized views that use relationships specified in dimensions. However, requests that have been rewritten by query rewrite may be invalidated, and subsequent operations on such views may execute more slowly.
The dimension must be in your own schema or you must have the
DIMENSION system privilege to use this statement.
Specify the name of the schema in which the dimension is located. If you omit
schema, then Oracle Database assumes the dimension is in your own schema.
Specify the name of the dimension you want to drop. The dimension must already exist.
Dropping a Dimension: Example This example drops the
DROP DIMENSION customers_dim;