Oracle - MVIEW
-- MVIEW更新確認
set lin100
set pages 99
col OWNER format a10
col MVIEW_NAME format a30
col REFRESH_MODE format a10
col LAST_REFRESH_TYPE format a10
col LAST_REFRESH_DATE format a20
ALTER SESSION SET NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss';
select OWNER,MVIEW_NAME,REFRESH_MODE,LAST_REFRESH_TYPE,LAST_REFRESH_DATE from user_mviews;
-- MVIEW手動更新
exec dbms_mview.refresh('MVIEW_NAME');
-- MVIEW更新停止
exec dbms_refresh.change(name => 'リフレッシュグループ名', next_date=> null, interval => 'null');