DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2001


    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,

  2. #2
    Join Date
    Feb 2001
    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

    ROhit Nirkhe,Oracle DBA,OCP 8i

  3. #3
    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.
    Ramon Caballero, DBA, rcaballe@yahoo.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.