DBA_MVIEW

DBA_MVIEW_KEYS

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

Columns
   ___________________________
 
   POSITION_IN_SELECT
      Position of this key within the SELECT list
   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
   CONTAINER_COLUMN
      Name of the column in the container table
   MVIEW_NAME
      Name of the materialized view
   OWNER
      Owner of the materialized view
   DETAILOBJ_OWNER
      Owner of the detail object

Related Commands:

Simon Sheppard
SS64.com