Mview refresh method convert from fast refresh to Complete.

Hello Oracle Enthusiasts,

We have lot of Remote MVs from multiple different MV sites created and being refreshed.All these MVs point to single table in master MV site.Its a mix of both fast and complete refresh Mviews so obviously has a respective Mview log table too.

Plan now is to convert all the Mviews that are setup for fast refreshes to Complete and get rid of the mview log altogether as size of mviews are very small.

based on my research found it can be done simply by using:

SQL> ALTER MATERIALIZED VIEW "<OWNER_SCHEMA>"."<MView_Name>" REFRESH COMPLETE;