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