Home Oracle Commands Oracle Data Dictionary
 v$ Performance views

ALL_REFRESH_DEPENDENCIES

Description of the detail tables that materialized views depend on for refresh 

Columns
   ___________________________
 
   TABLE_NAME
      Name of the dependent table
   PARENT_OBJECT_TYPE
      Materialized View
   OLDEST_REFRESH_SCN
      The oldest scn of a dependent materialized view
   OLDEST_REFRESH_DATE
      The oldest date scn of a dependent materialized view

Related:


Simon Sheppard
SS64.com