DBA_DIM_HIERARCHIES describes all the dimension hierarchies in the database. Its columns are the same as those in "ALL_DIM_HIERARCHIES".
DBA_DIM_HIERARCHIES
Scripting on this page enhances content navigation, but does not change the content in any way.