| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 | 
 | 
| 
 | PDF · Mobi · ePub | 
ALL_DIM_HIERARCHIES describes all dimension hierarchies accessible to the current user.
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 |