REFRESH_DEPENDENT Procedure
This procedure refreshes all materialized views that have the following properties:

The materialized view depends on a master table or master materialized view in the list of specified masters.
The materialized view has not been refreshed since the most recent change to a master table or master materialized view on which it depends.
The materialized view and all of the master tables or master materialized views on which it depends are local.
The materialized view is in the view DBA_MVIEWS.
This procedure is intended for use with data warehouses.

Syntax

DBMS_MVIEW.REFRESH_DEPENDENT (
   number_of_failures     OUT    BINARY_INTEGER,
   { list                 IN     VARCHAR2,
   | tab                  IN OUT DBMS_UTILITY.UNCL_ARRAY,}
   method                 IN     VARCHAR2    := NULL,
   rollback_seg           IN     VARCHAR2    := NULL,
   refresh_after_errors   IN     BOOLEAN     := false,
   atomic_refresh         IN     BOOLEAN     := true);

--------------------------------------------------------------------------------
Note:
This procedure is overloaded. The list and tab parameters are mutually exclusive.

--------------------------------------------------------------------------------