REFRESH_ALL_MVIEWS v17

Use the REFRESH_ALL_MVIEWS procedure to refresh any materialized views that weren't refreshed since the table or view on which the view depends was modified. The signature is:

REFRESH_ALL_MVIEWS(
  <number_of_failures> OUT BINARY_INTEGER,
  <method> IN VARCHAR2 DEFAULT NULL,
  <rollback_seg> IN VARCHAR2 DEFAULT NULL,
  <refresh_after_errors> IN BOOLEAN DEFAULT FALSE,
  <atomic_refresh> IN BOOLEAN DEFAULT TRUE);

Parameters

number_of_failures

number_of_failures is a BINARY_INTEGER that specifies the number of failures that occurred during the refresh.

method

method is a VARCHAR2 value that specifies the refresh method to apply to the specified views. The only supported method is C, which 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

This example performs a complete refresh on all materialized views:

DECLARE
  errors INTEGER;
BEGIN
  DBMS_MVIEW.REFRESH_ALL_MVIEWS(errors, method => 'C');
END;

Upon completion, errors contains the number of failures.