DBA_MVIEW_JOINS

DBA_MVIEW_JOINS describes a join between two columns in the WHERE clause of a subquery that defines a materialized view. Its columns are the same as those in "ALL_MVIEW_JOINS".

Related Views

· 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.

· USER_MVIEW_JOINS describes such joins for all materialized views owned by the current user.

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" prior to Oracle8i and that were never altered to enable query rewrite.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the materialized view
MVIEW_NAME	VARCHAR2(30)	NOT NULL	Materialized view name
DETAILOBJ1_OWNER	VARCHAR2(30)	NOT NULL	Owner of the first object in the join
DETAILOBJ1_RELATION	VARCHAR2(30)	NOT NULL	Name of the first object in the join
DETAILOBJ1_COLUMN	VARCHAR2(30)	NOT NULL	Join column of the first object in the join
OPERATOR	CHAR(1)		Join operator
OPERATOR_TYPE	VARCHAR2(1)		Whether the join is an inner or outer join
DETAILOBJ2_OWNER	VARCHAR2(30)	NOT NULL	Owner of the second object in the join
DETAILOBJ2_RELATION	VARCHAR2(30)	NOT NULL	Name of the second object in the join
DETAILOBJ2_COLUMN	VARCHAR2(30)	NOT NULL	Join column of the second object in the join

Oracle data dictionary views

Oracle dynamic performance views