Table: DBA_MVIEW_DETAIL_RELATIONS
Description of the materialized view detail tables accessible to dba
| Column Name | Description |
|---|---|
| DETAILOBJ_ALIAS | Alias of the detail relation if used |
| DETAILOBJ_NAME | Name of the materialized view detail table |
| DETAILOBJ_OWNER | Owner of the detail relation |
| DETAILOBJ_TYPE | Type of materialized detail table type |
| MVIEW_NAME | Name of the materialized view |
| OWNER | Owner of the materialized view |