Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
SQL Statements:
CREATE TYPE to
DROP ROLLBACK SEGMENT, 11 of 26
Use the DROP
DIMENSION
statement to remove the named dimension.
See Also:
|
The dimension must be in your own schema or you must have the DROP
ANY
DIMENSION
system privilege to use this statement.
drop_dimension::=
drop_dimension
Specify the name of the schema in which the dimension is located. If you omit schema, Oracle assumes the dimension is in your own schema.
Specify the name of the dimension you want to drop. The dimension must already exist.
DROP
DIMENSION
Example
This example drops the sh.customers_dim
dimension:
DROP DIMENSION customers_dim;
See Also:
"CREATE DIMENSION Example" and "Modifying a Dimension Examples" for examples of creating and modifying this dimension |
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|