Home Oracle Commands Oracle Data Dictionary
v$ Performance views

USER_MVIEW_DETAIL_RELATIONS

Description of the materialized view detail tables of the materialized views created by 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