Recompile mat. view

March 2nd, 2012
-- if compile_state = NEEDS_COMPILE
ALTER MATERIALIZED VIEW PRDECOM1.TBL_AM_ER_BUSTX_CNT COMPILE;
-- if STALENESS=STALE
exec dbms_mview.refresh( 'PRDECOM1.TBL_AM_ER_BUSTX_CNT');
Comments are closed.