how do I invalidate a materialized view?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: how do I invalidate a materialized view?

  1. #1
    Join Date
    Mar 2001
    Posts
    10

    Question

    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



  2. #2
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    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

  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