DBMS REFRESH
Jump to navigation
Jump to search
- 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: