1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: ALL_ALL_TABLES to ALL_OUTLINES
  4. ALL_HIERARCHIES

2.160 ALL_HIERARCHIES

ALL_HIERARCHIES describes the hierarchies accessible to the current user.

Related Views

  • DBA_HIERARCHIES describes all hierarchies in the database.

  • USER_HIERARCHIES describes the hierarchies owned by the current user. This view does not display the OWNER column.

Column Datatype NULL Description

OWNER

VARCHAR2(128)

NOT NULL

Owner of the hierarchy

HIER_NAME

VARCHAR2(128)

NOT NULL

Name of the hierarchy

DIMENSION_OWNER

VARCHAR2(128)

NOT NULL

Owner of the attribute dimension used by the hierarchy

DIMENSION_NAME

VARCHAR2(128)

NOT NULL

Name of the attribute dimension used by the hierarchy

PARENT_ATTR

VARCHAR2

Always NULL

COMPILE_STATE

VARCHAR2(7)

Compile status of the hierarchy:

  • VALID

  • INVALID

ORIGIN_CON_ID

NUMBER

The ID of the container where the data originates. Possible values include:

  • 0: This value is used for rows in non-CDBs. This value is not used for CDBs.

  • n: This value is used for rows containing data that originate in the container with container ID n (n = 1 if the row originates in root).

Note:

This view is available starting with Oracle Database 12c Release 2 (12.2.0.1).

See Also: