HI All,
Database version in 11g.
I have created a Materialized View with REFRESH FORCE ON COMMIT, as I want to track the new changes happened to the base tables.
MView got created successfully and loaded with the current set of records in the base tables.
I did a change to the base table records and I could not see the new changes to the MView.
When I verified the Last Refresh Date of the MView, it is showing the latest date.
MView Script
create materialized view MV_REF_CD_ID_TEST
build immediate
refresh force on commit
as
select rc.ref_cd, rc.ref_cd_id, rc.cntry_id, rc.div_id
from gxpnd_ods.t_ref_typ rt, gxpnd_ods.t_ref_cd rc
where rt.ref_typ_cd = 'Local CR ID Type'
and rt.ref_typ_id = rc.ref_typ_id
and rt.cntry_id = rc.cntry_id
and rt.div_id = rc.div_id;
I have also tried the dbms_mview.refresh procedure and still the data is not refreshed in the Mview.
I could not find out why the Mview is not getting the latest data even it shows it got refreshed.
Please help.