Hi All,
I have created a MV with complete refresh .I wanted to do incremental refresh can someone please let me know what needs to be done.I went through materialized views and it says that we need to create MVLog or this. I have MV with below definition
SELECT s.EQUIPMENT_FK_KEY EQUIPMENT_FK_KEY,
s.AVAILABILITY_DATE AVAILABILITY_DATE,
s.SHIFT_WORKDAY_FK_KEY SHIFT_WORKDAY_FK_KEY,
h.HOUR_PK_KEY HOUR_PK_KEY,
FROM tag_readings s, mth_hour_d h
where s.EQUIPMENT_FK_KEY IS NOT NULL
AND s.HOUR_FK_KEY IS NOT NULL
AND s.SHIFT_WORKDAY_FK_KEY IS NOT NULL
and s.to_time<=h.to_date
for doing fast refresh is it mandatory to have row_id columns in select query and also should MVLog be created on all base tables used in MV definition.
Thanks,
Amrit