Date: Thu, 27 Aug 2009 15:50:47 -0500
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 XuReceived on Thu Aug 27 2009 - 15:50:47 CDT