Table: USER_MVIEW_JOINS
Description of a join between two columns in the WHERE clause of a materialized view created by the user
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 | |
OWNER | Owner of the materialized view |