MV refresh

From: Roger Xu <>
Date: Thu, 27 Aug 2009 15:50:47 -0500
Message-ID: <>

Hi MV gurus,

Is it possible that when a MV is being refreshed but gets some kind of error and ends up an empty MV in 10g?

exec DBMS_MVIEW.refresh('MYMV','C'); - here is how we refresh.

The application team wants me to write a procedure to refresh MV and capture the error message if it fails and restore the MV to the previous state. How do I capture the error? I know I can show errors in SQL*PLUS.


Roger Xu

Received on Thu Aug 27 2009 - 15:50:47 CDT

Original text of this message