Thursday, January 31, 2008

Oracle MV Update

I love materialized views, but sometimes you need to be able to force their update. Just use the following Pl/SQL (I like using it from APEX where users need the ability to force the refresh

BEGIN
DBMS_MVIEW.REFRESH('NEWPORT.TRANSACTIONS_MV','C');
END;

No comments: