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