Re: materialized views

Tanel,
     Thanks for your response.

No, none of the underlying tables are altered.

As for the query rewrite, you just confirmed what
I thought. 

Do you know of a way to verify that the MV's 
are not being used ?

       Thanks again.

                   ed

On Thu, 5 Jan 2006 21:40:56 -0600, "Tanel Põder"
<tanel.poder.003@xxxxxxx> said:
> Hi,
> 
> > Many of them over time become invalid, after which
> > I recompile them and they're fine. But eventually,
> > they become invalid again. The vendor says that this
> 
> Do you alter any of the underlying tables the materialized view is based
> on?
> 
> > It appears all the MV's have the following characteristics :
> >     build immediate, refresh complete on demand.
> >     Query rewrite is not set in the MV definition.
> 
> Well is query rewrite isn't enabled for a materialized view, it can't be 
> used for rewrite, right?
> 
> >      query_rewrite_enabled   =  false
> 
> If query rewrite isn't enabled then it can't be used, right?
> 
> >      query_rewrite_integrity =  enforced
> 
> If query rewrite is not stale_tolerated and you have a stale materialized 
> view, then the query rewrite can't be used, right?
> 
> Tanel.
> 
> --
> http://www.freelists.org/webpage/oracle-l
> 
> 
-- 
  Edward Lewis
  eglewis@xxxxxxxxxxx

-- 
http://www.fastmail.fm - Or how I learned to stop worrying and
                          love email again

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


Other related posts: