Re: Materialized Views

From: Norbert Winkler <norbert.winkler1_at_gmx.de>
Date: Mon, 19 Apr 2010 17:46:42 +0200
Message-ID: <1bycvgt9x1wcc$.1xh4faym1v40m.dlg_at_40tude.net>

Am Thu, 15 Apr 2010 10:33:17 -0700 (PDT) schrieb The Magnet:

> Suggestions?

http://www.dba-oracle.com/art_9i_mv.htm
has some suggestions under "Refreshing materialized views"

I've tested succesfully:

---
EXECUTE DBMS_MVIEW.REFRESH('a_mat_view_name');
---
declare
  number_of_failures integer;
begin
DBMS_MVIEW.REFRESH_DEPENDENT(number_of_failures,'master_tab1,master_tab2,master_tab3');
end;
/
-------------
this fails:
DBMS_MVIEW.REFRESH_ALL_MVIEWS(number_of_failures);
-------------
and this (refresh on commit!!!!!) fails too for my views:
CREATE MATERIALIZED VIEW
   empdep
ON PREBUILT TABLE
REFRESH FAST ON COMMIT
ENABLE QUERY REWRITE
  AS SELECT empno, ename, dname, loc,
         e.rowid emp_rowid,
         d.rowid dep_rowid
    FROM emp e, dept d
   WHERE e.deptno = d.deptno;





-- 
Norbert
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit
Production

Received on Mon Apr 19 2010 - 10:46:42 CDT