materialized views [message #354145] |
Thu, 16 October 2008 10:14 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
nani_ar
Messages: 58 Registered: March 2006
|
Member |
|
|
Hi,
We have materialized views created with "refresh on demand" in our database. Our db is 10.1.0.5. But, the status for these materialized views in user_objects shows as "invalid". The status of 'compile_state' in user_mviews shows as "needs_compile". When I compile it manually, it becomes valid, and after sometime it restores back to the original state. They are getting refreshed normally, and the last_refresh_date shows the timing of refreshing.
Is it normal?
Wht would be the status of the materialized views (refresh on demand) in the user_objects in general?
Wht would be the status of "compile_state" for the above mviews in user_mviews in general?
Wht is the general behaviour of mat views?
All the replies are welcome.
Thx in advance
Regards
nani
|
|
|
Re: materialized views [message #354324 is a reply to message #354145] |
Fri, 17 October 2008 13:56 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
gkrishn
Messages: 506 Registered: December 2005 Location: Putty a dark screen
|
Senior Member |
|
|
i have observed the same. MVs switch between VALID and INVALID .i have not gone much detailed in to that.Pls post your findings if any
|
|
|