Materialized View

+++++++++++++++++++++++++++++++++++++
MVIEW refresh Status on MASTER Site :
+++++++++++++++++++++++++++++++++++++
set pages 1000
set linesize 180
col SNAPSHOT_SITE for a30
select r.name, r.snapshot_site, l.current_snapshots
from dba_registered_snapshots r, dba_snapshot_logs l
where r.snapshot_id = l.snapshot_id and l.master in (select master
from dba_snapshot_logs) ;
CLEAR COLUMNS


Show all materialized and resfresh times
========================================
set lines 100 pages 999
col last_refresh format a20
select owner
, mview_name
, to_char(last_refresh_date, 'dd/mm/yy hh24:mi') last_refresh
from dba_mviews
order by owner, last_refresh
/

Manually start a refresh
===========================

execute dbms_mview.refresh ('');

List all materialized view logs
=================================
select log_owner, log_table from dba_mview_logs;