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"  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_at_fastmail.fm

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

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