Re: materialized views

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