Difference between revisions of "DBMS REFRESH"
Jump to navigation
Jump to search
m (moved Dbms refresh to DBMS REFRESH) |
|||
| (7 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | * Destroy - Drop a refresh group | ||
| − | * Subtract | + | 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 ( | DBMS_REFRESH.SUBTRACT ( | ||
| Line 10: | Line 47: | ||
BEGIN | BEGIN | ||
DBMS_REFRESH.SUBTRACT ( | DBMS_REFRESH.SUBTRACT ( | ||
| − | name => ' | + | name => 'DVAG_REFRESH_GROUP', |
| − | list => 'SNAP$ | + | list => 'SNAP$_WORKFLOWS'); |
| + | commit; | ||
END; | END; | ||
/ | / | ||
| − | + | ||
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 10: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:
