This content has been marked as final. Show 2 replies
My real issue here is I no longer need the materialized views and I just want to remove them. I have recloned the target instance, so all of the materialized views have been blown away. Do I only need to remove the Materialized View Logs to completely remove them from my environment? Or is their something more that needs to be done.
That's all you need to do. If you used REFRESH GROUPS you can drop those and if you have any DBMS_JOBs that were used to refresh the MVs you won't need those anymore.
Naturally any code that directly referenced the MV logs or the MVs themselves will need to be modified to remove the references.
1) Drop Materialized view logs1 person found this helpful
2) Drop Materialized views
3) Stop or remove any jobs refreshing Materialized views OR drop any refresh group.