Difference between revisions of "DBMS REFRESH"
Jump to navigation
Jump to search
m (moved Dbms refresh to DBMS REFRESH) |
|||
| Line 1: | Line 1: | ||
| + | * Destroy | ||
| + | |||
| + | DBMS_REFRESH.DESTROY ( | ||
| + | name IN VARCHAR2); | ||
| + | |||
| + | BEGIN | ||
| + | DBMS_REFRESH.DESTROY ( | ||
| + | name => 'DVAG076'); | ||
| + | |||
| + | commit; | ||
| + | END; | ||
| + | / | ||
* Subtract | * Subtract | ||
| Line 12: | Line 24: | ||
name => 'DVAG076', | name => 'DVAG076', | ||
list => 'SNAP$_WORKFLOW_RULES'); | list => 'SNAP$_WORKFLOW_RULES'); | ||
| + | |||
| + | commit; | ||
END; | END; | ||
/ | / | ||
| − | + | ||
Reference: | Reference: | ||
* http://docs.oracle.com/cd/B28359_01/server.111/b28327/rarrefreshpac.htm#i94210 | * http://docs.oracle.com/cd/B28359_01/server.111/b28327/rarrefreshpac.htm#i94210 | ||
Revision as of 09: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:
