Difference between revisions of "DBMS REFRESH"
Jump to navigation
Jump to search
Line 7: | Line 7: | ||
DBMS_REFRESH.DESTROY ( | DBMS_REFRESH.DESTROY ( | ||
name => 'DVAG076'); | name => 'DVAG076'); | ||
− | |||
commit; | commit; | ||
END; | END; | ||
Line 24: | Line 23: | ||
name => 'DVAG076', | name => 'DVAG076', | ||
list => 'SNAP$_WORKFLOW_RULES'); | list => 'SNAP$_WORKFLOW_RULES'); | ||
− | |||
commit; | commit; | ||
END; | END; |
Revision as of 10:42, 17 November 2011
- Destroy
DBMS_REFRESH.DESTROY ( name IN VARCHAR2);
BEGIN DBMS_REFRESH.DESTROY ( name => 'DVAG076'); 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 => 'DVAG076', list => 'SNAP$_WORKFLOW_RULES'); commit; END; /
Reference: