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
   ___________________________
 
   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
   OWNER
      Owner of the materialized view
   DETAILOBJ_ALIAS
      Alias of the detail relation if used

Related Commands:



Back to the Top

Simon Sheppard
 SS64.com