ALL_DIM_HIERARCHIES describes all dimension hierarchies accessible to the current user.

Related Views

  • DBA_DIM_HIERARCHIES describes all such hierarchies in the database.

  • USER_DIM_HIERARCHIES describes all such hierarchies owned by the current user.

Column Datatype NULL Description
OWNER VARCHAR2(30) NOT NULL Owner of the dimension
DIMENSION_NAME VARCHAR2(30) NOT NULL Name of the dimension
HIERARCHY_NAME VARCHAR2(30)   Hierarchy name