ALL_DIM_HIERARCHIES

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