Table: DBA_MVIEW_JOINS
Description of a join between two columns in the WHERE clause of a materialized view accessible to dba
| Column Name | Description |
|---|---|
| DETAILOBJ1_COLUMN | Name of the 1st detail object column |
| DETAILOBJ1_OWNER | Owner of the 1st detail object |
| DETAILOBJ1_RELATION | Name of the 1st detail object |
| DETAILOBJ2_COLUMN | Name of the 2nd detail object column |
| DETAILOBJ2_OWNER | Owner of the 2nd detail object |
| DETAILOBJ2_RELATION | Name of the 2nd detail object |
| MVIEW_NAME | Name of the materialized view |
| OPERATOR | Name of the join operator. Currently only = is defined |
| OPERATOR_TYPE | Indicates inner or outer join. I = inner join, L = DETAILOBJ1 table is the left side of an outer join, R = DETAILOBJ2 table is the right side of an outer join |
| OWNER | Owner of the materialized view |