ALL_DIMENSIONS

ALL_DIMENSIONS describes dimension objects accessible to the current user.

Related views:

• DBA_DIMENSIONS describes all dimensions in the database.

• USER_DIMENSIONS describes 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)		Whether the dimension is invalid (Y/N)
  REVISION	NUMBER		Dimension revision level