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!

check materialized view refresh history

592815Jun 24 2009 — edited Jun 24 2009

Hi Experts,

I have a materialized view with refreshed as
START WITH TO_DATE('22-06-2009 16:21:34', 'DD-MM-YYYY HH24:MI:SS') NEXT /*15:MINS*/ SYSDATE + 15/(60*24)

How can we check materivalized freshed status and refreshed history?

I can not find info by below SQL
select JOB, SCHEMA_USER ,
LAST_DATE,LAST_SEC ,THIS_DATE,THIS_SEC,NEXT_DATE,
BROKEN, INTERVAL,FAILURES ,WHAT
from dba_jobs
where job= 373232

Thanks
JIM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 22 2009

Added on Jun 24 2009

#general-database-discussions

3 comments

1,740 views