|
|
ALTER DIMENSION
Alter a dimension (data warehouse parent-child relationship.)
Syntax:
ALTER DIMENSION [schema.]dimension ADD level_clause(s) ADD [heirarchy_clause(s) ADD attribute_clause(s)]; ALTER DIMENSION [schema.]dimension COMPILE; ALTER DIMENSION [schema.]dimension DROP LEVEL level [RESTRICT|CASCADE]; ALTER DIMENSION [schema.]dimension DROP HEIRARCHY heirarchy; ALTER DIMENSION [schema.]dimension DROP ATTRIBUTE attribute;
Multiple drop statements can be combined in a single command
e.g. ALTER DIMENSION... DROP ATTRIBUTE... , DROP DIMENSION...;
level_clause: LEVEL level IS (table.column,...) heirarchy_clause: HEIRARCHY heirarchy (child_level CHILD OF parent_level,... [join_clause]) attribute_clause: ATTRIBUTE level DETERMINES (dependent_column,...) join_clause: JOIN KEY (child_key_column,...) REFERENCES parent_level
Related Commands:
DIMENSION - CREATE DIMENSION
DIMENSION - DROP DIMENSION
MVIEW - CREATE MATERIALIZED VIEW
DBMS_UTILITY - Compile
pl/sql package
Related Views:
DBA_DEPENDENCIES ALL_DEPENDENCIES USER_DEPENDENCIES