If the refresh group is going to contain a materialized view that is already a member of another
refresh group (for example, during a move of a materialized view from an old refresh group to a
newly created refresh group), you must set the lax parameter to TRUE. A materialized view can
only belong to one refresh group at a time.
To add materialized views to an existing refresh group, use the ADD procedure of the DBMS_
REFRESH package, whose parameters are as follows:
DBMS_REFRESH.ADD
(name IN VARCHAR2,
list IN VARCHAR2, |
tab IN DBMS_UTILITY.UNCL_ARRAY,
lax IN BOOLEAN := FALSE);
As with the MAKE procedure, the ADD procedure??™s lax parameter does not have to be specified
unless a materialized view is being moved between two refresh groups. When this procedure is
executed with the lax parameter set to TRUE, the materialized view is moved to the new refresh
group and is automatically deleted from the old refresh group.
To remove materialized views from an existing refresh group, use the SUBTRACT procedure
of the DBMS_REFRESH package, as in the following example:
DBMS_REFRESH.SUBTRACT
(name IN VARCHAR2,
list IN VARCHAR2, |
tab IN DBMS_UTILITY.UNCL_ARRAY,
lax IN BOOLEAN := FALSE);
As with the MAKE and ADD procedures, a single materialized view or a list of materialized
views (separated by commas) may serve as input to the SUBTRACT procedure. You can alter the
refresh schedule for a refresh group via the CHANGE procedure of the DBMS_REFRESH package;
here are the parameters:
DBMS_REFRESH.
Pages:
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918