how do I invalidate a materialized view?

[eddieh]

I have a materialized view which refreshes itself every 10 mins. I have SQL clients which talk directly to the mview. There are instances when a SQL client is querying the mview while its being refreshed which returns 0 records.

Is there a way I can invalidate the mview so that the SQL client gets some type of exception stating that the mview is unavailable or in an invalid state?

thanks in advance,
-Eddie

[rohitsn]

Hi,
See refreshing materialised view every after 10 minutes puts a lot of processing on the server and the network.It is best to refresh the materialised view during night.In case if u want to refresh the views after evry 10 minutes,plan out the refresh times and tell to the users about the plan of the refreshal time.
In case of any help please be free to write to me at rohitsn@altavista.com


Regards,
ROhit Nirkhe,Oracle DBA,OCP 8i
rohitsn@altavista.com

[rcaballe]

I guess that to use properly a MV you don't talk directly to it, you must use Query Rewrite feature and I hope Oracle take care of to do or not to do query rewrite in the meantime of the refresh.