--查看记录数

declare

 v_output number;

begin

  for c_cursor in (select tname from tab where tname like 'MLOG%') LOOP

    execute immediate 'select count(*) from ' || c_cursor.tname into v_output;

    dbms_output.put_line(substr(c_cursor.tname, 7) || ' count(*) is ' || v_output);

  end loop;

end;

/

select * from dba_base_table_mviews;

select * from sys.dba_registered_mviews t

DBMS_MVIEW.UNREGISTER_MVIEW (

   mviewowner      IN   VARCHAR2,

   mviewname       IN   VARCHAR2,

   mviewsite       IN   VARCHAR2);

PURGE_MVIEW_FROM_LOG过程进行了重载，可以输入MVIEW_ID或输入MVIEWOWNER、MVIEWNAME、MVIEWSITE。

EXEC DBMS_MVIEW.PURGE_MVIEW_FROM_LOG(534)

SQL> begin

  2  for i in (select mview_id from dba_base_table_mviews where mview_last_refresh_time < trunc(sysdate)) loop

  3  dbms_mview.purge_mview_from_log(i.mview_id);

  4  end loop;

  5  commit;

  6  end;

  7  /