Question regarding materialized view
I have a materialized view log created on one server and materialized view created on another replicated server. The materialized view get refreshed every 30 minutes.
However, the materialized view log gets dropped pretty often after running MRP process. Of course, the refresh will fail when the materialized view log does not exist.
My question is, if I rebuild the materialized view log after it gets dropped, but does not drop and rebuild the old materialized view associated with the dropped materialized view log. Will the view still be able to get refreshed after I recreate the materialized view log?