December 2002
Intermediate to advanced
928 pages
85h 29m
English
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, ...