Home Oracle Commands Oracle Data Dictionary
 v$ Performance views

ALL_MVIEW_DETAIL_RELATIONS

Description of the materialized view detail tables accessible to the user 

Columns
   ___________________________
 
   OWNER
      Owner of the materialized view
   MVIEW_NAME
      Name of the materialized view
   DETAILOBJ_OWNER
      Owner of the detail relation
   DETAILOBJ_NAME
      Name of the materialized view detail table
   DETAILOBJ_TYPE
      Type of materialized view detail table type
   DETAILOBJ_ALIAS
      Alias of the detail relation if used

Related:


Simon Sheppard
SS64.com