Oracle in a Nutshell

Calls

PROCEDURE DBMS_REFRESH.ADD (name IN VARCHAR2, {list IN VARCHAR2 | tab IN DBMS_UTILITY.UNCL_ARRAY}, lax IN BOOLEAN := FALSE);

Adds members in list or tab to group name. If you are moving a materialized view from one group to another, lax must be TRUE.

PROCEDURE DBMS_REFRESH.CHANGE (name IN VARCHAR2, next_date IN DATE := NULL, interval IN VARCHAR2 := NULL, implicit_destroy IN BOOLEAN := NULL, rollback_seg IN VARCHAR2 := NULL, push_deferred_rpc IN BOOLEAN := NULL, refresh_after_errors IN BOOLEAN := NULL, purge_option IN BINARY_INTEGER := NULL parallelism IN BINARY_INTEGER := NULL, heap_size IN BINARY_INTEGER := NULL);

Changes the interval for refresh group name, starting with next_date. The remaining parameters alter other characteristics of the refresh group, as described in the MAKE procedure.

PROCEDURE DBMS_REFRESH.DESTROY (name IN VARCHAR);

Removes materialized views from name and deletes the group.

PROCEDURE DBMS_REFRESH.MAKE (name IN VARCHAR2, {list IN VARCHAR2 | tab IN DBMS_UTILITY.UNCL_ARRAY}, next_date IN DATE := NULL, interval IN VARCHAR2 := NULL, implicit_destroy IN BOOLEAN := FALSE, lax IN BOOLEAN := NULL, job IN BINARY_INTEGER := 0, rollback_seg IN VARCHAR2 := NULL, push_deferred_rpc IN BOOLEAN := TRUE, refresh_after_errors IN BOOLEAN := FALSE, purge_option IN BINARY_INTEGER := NULL parallelism IN BINARY_INTEGER := NULL, heap_size IN BINARY_INTEGER := NULL);

Creates refresh group name from list or tab. The interval for refresh group name is the time between refreshes, ...