DBMS REFRESH - Revision history

Ittichai at 16:03, 17 November 2011

2011-11-17T16:03:51Z

Ittichai at 16:00, 17 November 2011

2011-11-17T16:00:42Z

Ittichai at 16:00, 17 November 2011

2011-11-17T16:00:04Z

Ittichai at 15:59, 17 November 2011

2011-11-17T15:59:48Z

Ittichai at 15:59, 17 November 2011

2011-11-17T15:59:28Z

Ittichai at 15:59, 17 November 2011

2011-11-17T15:59:03Z

Ittichai at 15:42, 17 November 2011

2011-11-17T15:42:52Z

Ittichai at 15:42, 17 November 2011

2011-11-17T15:42:33Z

Ittichai: moved Dbms refresh to DBMS REFRESH

2011-11-17T15:31:06Z

moved Dbms refresh to DBMS REFRESH

Ittichai: Created page with " * Subtract DBMS_REFRESH.SUBTRACT ( name IN VARCHAR2, { list IN VARCHAR2, | tab IN DBMS_UTILITY.UNCL_ARRAY, } lax IN BOOLEAN := false)..."

2011-11-17T15:30:26Z

Created page with " * Subtract DBMS_REFRESH.SUBTRACT ( name IN VARCHAR2, { list IN VARCHAR2, | tab IN DBMS_UTILITY.UNCL_ARRAY, } lax IN BOOLEAN := false)..."

New page

* 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');
END;
/

commit;

Reference:
* http://docs.oracle.com/cd/B28359_01/server.111/b28327/rarrefreshpac.htm#i94210

@@ Line 1: / Line 1: @@
-* Destroy
+* Destroy - Drop a refresh group
   DBMS_REFRESH.DESTROY (
@@ Line 11: / Line 11: @@
+  /
-* Subtract
+* Create a new refresh group
   DBMS_REFRESH.SUBTRACT (

← Older revision		Revision as of 16:00, 17 November 2011
Line 30:		Line 30:

	Reference:		Reference:
−	* [http://docs.oracle.com/cd/B28359_01/server.111/b28327/rarrefreshpac.htm~~#i94210~~ Oracle Documentation]	+	* [http://docs.oracle.com/cd/B28359_01/server.111/b28327/rarrefreshpac.htm Oracle Documentation]

← Older revision		Revision as of 16:00, 17 November 2011
Line 30:		Line 30:

	Reference:		Reference:
−	* [[http://docs.oracle.com/cd/B28359_01/server.111/b28327/rarrefreshpac.htm#i94210 Oracle Documentation]]	+	* [http://docs.oracle.com/cd/B28359_01/server.111/b28327/rarrefreshpac.htm#i94210 Oracle Documentation]

← Older revision		Revision as of 15:59, 17 November 2011
Line 30:		Line 30:

	Reference:		Reference:
−	* [[http://docs.oracle.com/cd/B28359_01/server.111/b28327/rarrefreshpac.htm#i94210\|Oracle Documentation]]	+	* [[http://docs.oracle.com/cd/B28359_01/server.111/b28327/rarrefreshpac.htm#i94210 Oracle Documentation]]

← Older revision		Revision as of 15:59, 17 November 2011
Line 30:		Line 30:

	Reference:		Reference:
−	* [[~~Oracle Doc \|~~ 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\|Oracle Documentation]]

@@ Line 6: / Line 6: @@
   BEGIN
   DBMS_REFRESH.DESTROY (
-    name   =>   'DVAG076');
+    name   =>   'DVAG_REFRESH_GROUP');
   commit;
   END;
@@ Line 21: / Line 21: @@
   BEGIN
   DBMS_REFRESH.SUBTRACT (
-    name      =>    'DVAG076',
+    name      =>    'DVAG_REFRESH_GROUP',
-    list      =>    'SNAP$_WORKFLOW_RULES');
+    list      =>    'SNAP$_WORKFLOWS');
   commit;
   END;
@@ Line 30: / Line 30: @@
 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]]

← Older revision	Revision as of 15:31, 17 November 2011
(No difference)