DBA_MVIEW

DBA_MVIEW_JOINS

Description of a join between two columns in the WHERE clause of a materialized view accessible to dba

Columns
   ___________________________
 
   DETAILOBJ1_OWNER
      Owner of the 1st detail object
   OWNER
      Owner of the materialized view
   MVIEW_NAME
      Name of the materialized view
   DETAILOBJ1_RELATION
      Name of the 1st detail object
   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
   DETAILOBJ2_OWNER
      Owner of the 2nd detail object
   DETAILOBJ2_RELATION
      Name of the 2nd detail object
   DETAILOBJ2_COLUMN
      Name of the 2nd detail object column
   DETAILOBJ1_COLUMN
      Name of the 1st detail object column

Related Commands:

Simon Sheppard
SS64.com