2.123 ALL_DIMENSIONS

ALL_DIMENSIONS describes the dimension objects accessible to the current user.

Related Views

  • DBA_DIMENSIONS describes all dimensions in the database.

  • USER_DIMENSIONS describes the dimensions in the current user's schema.

Column Datatype NULL Description

OWNER

VARCHAR2(128)

NOT NULL

Owner of the dimension

DIMENSION_NAME

VARCHAR2(128)

NOT NULL

Name of the dimension

INVALID

VARCHAR2(1)

Indicates whether the dimension is invalid (Y) or valid (N)

COMPILE_STATE

VARCHAR2(13)

Compile status of the dimension:

  • INVALID

  • NEEDS_COMPILE

  • ERROR

REVISION

NUMBER

Dimension revision level