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(30) NOT NULL Owner of the dimension
DIMENSION_NAME VARCHAR2(30) 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