Difference between revisions of "DBMS REFRESH"
Jump to navigation
Jump to search
| Line 6: | Line 6: | ||
BEGIN | BEGIN | ||
DBMS_REFRESH.DESTROY ( | DBMS_REFRESH.DESTROY ( | ||
| − | name => ' | + | name => 'DVAG_REFRESH_GROUP'); |
commit; | commit; | ||
END; | END; | ||
| Line 21: | Line 21: | ||
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 30: | ||
Reference: | Reference: | ||
| − | * http://docs.oracle.com/cd/B28359_01/server.111/b28327/rarrefreshpac.htm#i94210 | + | * [[Oracle Doc | http://docs.oracle.com/cd/B28359_01/server.111/b28327/rarrefreshpac.htm#i94210]] |
Revision as of 10:59, 17 November 2011
- Destroy
DBMS_REFRESH.DESTROY ( name IN VARCHAR2);
BEGIN DBMS_REFRESH.DESTROY ( name => 'DVAG_REFRESH_GROUP'); commit; END; /
- Subtract
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:
