delete

Some useful selects to check materialize...

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;