Difference between revisions of "DBMS REFRESH"
Jump to navigation
Jump to search
(5 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
− | * Destroy | + | * Destroy - Drop a refresh group |
DBMS_REFRESH.DESTROY ( | DBMS_REFRESH.DESTROY ( | ||
Line 6: | Line 6: | ||
BEGIN | BEGIN | ||
DBMS_REFRESH.DESTROY ( | DBMS_REFRESH.DESTROY ( | ||
− | name => ' | + | name => 'DVAG_REFRESH_GROUP'); |
commit; | commit; | ||
END; | END; | ||
/ | / | ||
− | * Subtract | + | * 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 ( | DBMS_REFRESH.SUBTRACT ( | ||
Line 21: | Line 47: | ||
BEGIN | BEGIN | ||
DBMS_REFRESH.SUBTRACT ( | DBMS_REFRESH.SUBTRACT ( | ||
− | name => ' | + | name => 'DVAG_REFRESH_GROUP', |
− | list => 'SNAP$ | + | list => 'SNAP$_WORKFLOWS'); |
commit; | commit; | ||
END; | END; | ||
Line 30: | Line 56: | ||
Reference: | Reference: | ||
− | * http://docs.oracle.com/cd/B28359_01/server.111/b28327/rarrefreshpac.htm | + | * [http://docs.oracle.com/cd/B28359_01/server.111/b28327/rarrefreshpac.htm Oracle Documentation] |
Latest revision as of 11:03, 17 November 2011
- 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: