| Table Name | Description |
| ALL_DIM_HIERARCHIES | Representation of a dimension hierarchy |
| Column ID | Column name | Data type | Length | Precision | NULL | Description |
| 1 | OWNER | VARCHAR2 | 30 | (null) | N | Owner of the dimension |
| 2 | DIMENSION_NAME | VARCHAR2 | 30 | (null) | N | Name of the dimension |
| 3 | HIERARCHY_NAME | VARCHAR2 | 30 | (null) | Y | Name of the hierarchy |