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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
