MVIEW REFRESH ISSUE

Hi Team,

We are using below oracle version in my project, what we observed that whenever we do MVIEW First refresh it basically deleting old entry from MVIEW data set and reinsert new data set, as a result the trigger on that MVIEW inserting two records in some tables, one for delete another for Insert , but it should be single update.

"Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.8.0.0.0"

Could you please help here?

PFB the trigger syntax

create or replace

TRIGGER TEST_DATA_TRG

AFTER INSERT OR UPDATE OR DELETE

ON MV_TEST_DATA

REFERENCING OLD AS old NEW AS new