RE: MV including clause

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: