RE: MV including clause

  • From: Freeman Robert - IL <FREEMANR@xxxxxxxx>
  • To: 'David ' <thump@xxxxxxxxxxxxxxxx>, "'oracle-l-bounce@xxxxxxxxxxxxx '" <oracle-l-bounce@xxxxxxxxxxxxx>, "'oracle-l@xxxxxxxxxxxxx '" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 30 Sep 2004 10:38:17 -0500

Have you used the dbms_mview.explain_mview procedure. It will tell you
exactly why your mview will not refresh.

RF

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
To: oracle-l@xxxxxxxxxxxxx
Sent: 9/30/2004 9:41 AM
Subject: MV including clause

Does anyone have expeirence with using including clause on a
materialized
view and can make a comparision of the overhead of including vs
excluding?
Any other hints, tips, pros, cons would be great.
I have a complex query that won't work with excluding clause as an MV.
Thanks
-- 
..
David

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Other related posts: