Hi,
on 8.1.7.4
today about noon I created a materialized view with :
REATE MATERIALIZED VIEW .......................
...........................................................
REFRESH FAST
START WITH TO_DATE('07-jul-2010 12:57:47','dd-mon-yyyy hh24:mi:ss')
NEXT SYSDATE+1/24
..........................
...................................
But now when I query the views I have :
select next_date,what from dba_jobs where what like '%MV%'
NEXT_DATE|WHAT
07/07/2010 12:57:47|dbms_refresh.refresh('"schema"."MV"');
SELECT RNAME,
ROWNER,
BROKEN,
TO_CHAR(NEXT_DATE, 'DD-MON-YYYY HH:MI:SS AM') next_refresh,
INTERVAL
FROM DBA_REFRESH
WHERE RNAME like '%MV%'
ORDER BY 1;
RNAME|ROWNER|BROKEN|NEXT_REFRESH|INTERVAL
MV|SCHEMA|N|07-JUL-2010 12:57:47 PM|SYSDATE+1/24
Then it is not activated or ? Should do something more to make it activated or to start it ?
Thanks.