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
   ___________________________
 
   DETAILOBJ_ALIAS
      Alias of the detail relation if used
   DETAILOBJ_OWNER
      Owner of the detail relation
   MVIEW_NAME
      Name of the materialized view
   DETAILOBJ_NAME
      Name of the materialized view detail table
   OWNER
      Owner of the materialized view
   DETAILOBJ_TYPE
      Type of materialized view detail table type

Related Commands:



Back to the Top

Simon Sheppard
 SS64.com