ALL_MVIEW

ALL_MVIEW_KEYS

Description of the columns that appear in the GROUP BY list of a materialized view accessible to the user

Columns
   ___________________________
 
   DETAILOBJ_COLUMN
      Name of the detail object column
   DETAILOBJ_TYPE
      Type of the detail object: VIEW or TABLE
   DETAILOBJ_ALIAS
      Alias of the detail object
   DETAILOBJ_NAME
      Name of the detail object
   DETAILOBJ_OWNER
      Owner of the detail object
   CONTAINER_COLUMN
      Name of the column in the container table
   POSITION_IN_SELECT
      Position of this key within the SELECT list
   MVIEW_NAME
      Name of the materialized view
   OWNER
      Owner of the materialized view

Related Commands:

Simon Sheppard
SS64.com