Home Oracle Commands Oracle Data Dictionary
 v$ Performance views

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

Related:


Simon Sheppard
SS64.com