DBA_DIMENSIONS

Description of the dimension objects accessible to the DBA

Columns
   ___________________________
 
   OWNER
      Owner of the dimension
   DIMENSION_NAME
      Name of the dimension
   INVALID
      Invalidity of the dimension,Y = INVALID,N = VALID.  The column is deprecated
   COMPILE_STATE
      Compile status of the dimension,VALID/NEEDS_COMPILE/ERROR
   REVISION
      Revision levle of the dimension