ALL_MVIEW_JOINS
ALL_MVIEW_JOINS describes joins between two columns in the WHERE clause of the subquery that defines a materialized view accessible to the current user.
Related Views
-
DBA_MVIEW_JOINSdescribes all such joins for all materialized views in the database. -
USER_MVIEW_JOINSdescribes such joins for all materialized views owned by the current user.
Note: All three views exclude materialized views that reference remote tables or that includes references to a nonstatic value such as SYSDATE or USER. These views also exclude materialized views that were created as “snapshots” before Oracle8i and that were never altered to enable query rewrite.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(128) |
NOT NULL |
Owner of the materialized view |
MVIEW_NAME |
VARCHAR2(128) |
NOT NULL |
Materialized view name |
DETAILOBJ1_OWNER |
VARCHAR2(128) |
NOT NULL |
Owner of the first object in the joinFoot 1 |
DETAILOBJ1_RELATION |
VARCHAR2(128) |
NOT NULL |
Name of the first object in the joinFoot 1 |
DETAILOBJ1_COLUMN |
VARCHAR2(128) |
NOT NULL |
Join column of the first object in the joinFoot 1 |
OPERATOR |
CHAR(1) |
Join operatorFoot 1 | |
OPERATOR_TYPE |
VARCHAR2(1) |
Indicates whether the join is an inner join (I) or the DETAILOBJ1 table is the left side of an outer join (L)Foot 1 |
|
DETAILOBJ2_OWNER |
VARCHAR2(128) |
NOT NULL |
Owner of the second object in the joinFoot 1 |
DETAILOBJ2_RELATION |
VARCHAR2(128) |
NOT NULL |
Name of the second object in the joinFoot 1 |
DETAILOBJ2_COLUMN |
VARCHAR2(128) |
NOT NULL |
Join column of the second object in the joinFoot 1 |
Footnote 1
These rows relate only to materialized join views and materialized aggregate views. They describe the two detail objects of a materialized view join.
See Also: