REFRESH_ALL_MVIEWS v13
Use the REFRESH_ALL_MVIEWS
procedure to refresh any materialized views that have not been refreshed since the table or view on which the view depends has been modified. The signature is:
Parameters
number_of_failures
number_of_failures
is a BINARY_INTEGER
that specifies the number of failures that occurred during the refresh operation.
method
method
is a VARCHAR2
value that specifies the refresh method that will be applied to the specified view (or views). The only supported method is C;
this performs a complete refresh of the view.
rollback_seg
rollback_seg
is accepted for compatibility and ignored. The default is NULL
.
refresh_after_errors
refresh_after_errors
is accepted for compatibility and ignored. The default is FALSE
.
atomic_refresh
atomic_refresh
is accepted for compatibility and ignored. The default is TRUE
.
Examples
The following example performs a COMPLETE
refresh on all materialized views:
Upon completion, errors
contains the number of failures.