Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

next refresh date

happy10319Jul 7 2010 — edited Jul 16 2010
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.
This post has been answered by fjfranken on Jul 7 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 13 2010
Added on Jul 7 2010
5 comments
2,289 views