Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> materialized views
Hello,
I'm supporting a 3rd party applicaton running on AIX 5.2L with Oracle 9.2.0.7.
The app makes use of materialized views. 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 is because the materialized views were imported into the database, and must be refreshed again. I did that, but still have the same problems.
Any ideas why this happens ?
I checked v$sql and it appears that the MV's are not being used. Is there something else I can check to verify this ? 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. Here are the database settings for the following : query_rewrite_enabled = false query_rewrite_integrity = enforced
Your input is appreciated.
ed
--
Edward Lewis
eglewis_at_fastmail.fm
--
http://www.fastmail.fm - A no graphics, no pop-ups email service
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 05 2006 - 16:53:16 CST
![]() |
![]() |