Home » RDBMS Server » Server Administration » materialized views (10.1.0.5)
materialized views [message #354145] Thu, 16 October 2008 10:14 Go to next message
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
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
Previous Topic: Cloning database - Recreate undo
Next Topic: Rename Table
Goto Forum:
  


Current Time: Sun Dec 04 06:25:51 CST 2016

Total time taken to generate the page: 0.03984 seconds