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:
Post a Comment