DBA_MVIEW_KEYS
Description of the columns that appear in the list of a materialized view accessible to dbaColumns
___________________________
GROUP BY OWNER
Owner of the materialized view
GROUP BY MVIEW_NAME
Name of the materialized view
GROUP BY POSITION_IN_SELECT
Position of this key within the SELECT list
GROUP BY CONTAINER_COLUMN
Name of the column in the container table
GROUP BY DETAILOBJ_OWNER
Owner of the detail object
GROUP BY DETAILOBJ_NAME
Name of the detail object
GROUP BY DETAILOBJ_ALIAS
Alias of the detail object
GROUP BY DETAILOBJ_TYPE
Type of the detail object: VIEW or TABLE
GROUP BY DETAILOBJ_COLUMN
Name of the detail object column
Related: