Materialized view becoming invalid after a DML on base table(s)
A sample of the create materialized view is listed below, with the refresh statement at the very end:
CREATE MATERIALIZED VIEW "SCOTT"."MV_SAMPLER"
TABLESPACE "TEST_DATA"
BUILD IMMEDIATE
USING INDEX TABLESPACE "TEST_INDEX"
REFRESH FORCE ON DEMAND