Some useful selects to check materialized views

Show refresh method for existing MVs:


SELECT mview_name, refresh_mode, refresh_method, last_refresh_type, last_refresh_date FROM user_mviews;

Show existing logs for materialized views:


SELECT log_owner, master, log_table        FROM dba_mview_logs;

 

Leave a Reply

Your email address will not be published. Required fields are marked *