REFRESH_ALL_MVIEWS procedure

This procedure refreshes all snapshots (materialized views) with the following properties:

• The snapshot has not been refreshed since the most recent change to a master table on which it depends.

• The snapshot and all of the master tables on which it depends are local.

• The snapshot is in the view DBA_MVIEWS.

This procedure is intended for use with data warehouses.

Syntax

DBMS_SNAPSHOT.REFRESH_ALL_MVIEWS (
   number_of_failures     OUT   BINARY_INTEGER,
   method                 IN    VARCHAR2         := NULL,
   rollback_seg           IN    VARCHAR2         := NULL,
   refresh_after_errors   IN    BOOLEAN          := FALSE,
   atomic_refresh         IN    BOOLEAN          := TRUE);

Parameters

Table 8-311 REFRESH_ALL_MVIEWS Procedure Parameters (Page 1 of 2)

Parameter	Description
number_of_failures	Returns the number of failures that occurred during processing.
method	A single refresh method indicating the type of refresh to perform for each snapshot that is refreshed. F or f indicates fast refresh, ? indicates force refresh, C or c indicates complete refresh, and A or a indicates always refresh. If no method is specified, a snapshot is refreshed according to its default refresh method.
rollback_seg	Name of the snapshot site rollback segment to use while refreshing snapshots.
refresh_after_errors	If this parameter is TRUE, an updatable snapshot continues to refresh even if there are outstanding conflicts logged in the DEFERROR view for the snapshot's master table. If this parameter is TRUE and atomic_refresh is FALSE, this procedure continues to refresh other snapshots if it fails while refreshing a snapshot.
atomic_refresh	If this parameter is set to TRUE, then the refreshed snapshots are refreshed in a single transaction. All of the refreshed snapshots are updated to a single point in time. If the refresh fails for any of the snapshots, none of the snapshots are updated. If this parameter is set to FALSE, then each of the refreshed snapshots is refreshed in a separate transaction. The number of job queue processes must be set to 1 or greater if this parameter is FALSE.