Home » RDBMS Server » Server Administration » materialized views (
materialized views [message #354145] Thu, 16 October 2008 10:14 Go to next message
Messages: 58
Registered: March 2006
We have materialized views created with "refresh on demand" in our database. Our db is 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
Re: materialized views [message #354324 is a reply to message #354145] Fri, 17 October 2008 13:56 Go to previous message
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
Previous Topic: Cloning database - Recreate undo
Next Topic: Rename Table
Goto Forum:

Current Time: Fri Oct 21 10:15:23 CDT 2016

Total time taken to generate the page: 0.10596 seconds