DBMS REFRESH


 * Destroy - Drop a refresh group

DBMS_REFRESH.DESTROY (  name   IN   VARCHAR2);

BEGIN DBMS_REFRESH.DESTROY (  name   =>   'DVAG_REFRESH_GROUP'); commit; END; /


 * Create a new refresh group

DBMS_REFRESH.MAKE (  name                  IN    VARCHAR2   { list                IN    VARCHAR2,   | tab                 IN    DBMS_UTILITY.UNCL_ARRAY,}   next_date             IN    DATE,   interval              IN    VARCHAR2,   implicit_destroy      IN    BOOLEAN         := FALSE,   lax                   IN    BOOLEAN         := FALSE,   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);


 * Add mviews into a refresh group

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


 * Subtract - Remove mviews from a refresh group

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

BEGIN DBMS_REFRESH.SUBTRACT (  name      =>    'DVAG_REFRESH_GROUP',   list      =>    'SNAP$_WORKFLOWS'); commit; END; /

Reference:
 * Oracle Documentation