-- 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');