This content has been marked as final. Show 3 replies
You have to use COMPLETE refresh method for all MV that depend on table where you drop and create MV log.
replace SCHEMA.MV_NAME with your values.
BEGIN dbms_mview.refresh(list => 'SCHEMA.MV_NAME',method => 'C'); END; /
Thanks. I read the documentation on this command and it is not clear.
So, I am assuming it will keep on refreshing the view (every 10 seconds) after this???
Regular refresh depend on how you define it. When you defined resfresh interval to 10s then yes.