Re: materialized view not refreshing

"Chuck" <chuckhNOSPAM_at_softhome.net> wrote in message news:acm20r$q6mmo$1_at_ID-85580.news.dfncis.de...
> I have a fast refresh materialized view that stopped refreshing yesterday
> and I don't know why. The link works. I can execute the mview query just
> fine. When I run dbms_refresh.refresh, the procedure completes succesfully
> but the mview is not refreshed. Anyone know what's going on? Did the mview
> log get corrupted some how? If so how do you rebuild it?
>
> The only I way I can get it to refresh now is through the OEM console by
> manually running a complete refresh. Even then, the data gets refreshed
but
> dba_mviews_analysis.last_refresh_date does not show the time of the
complete
> refresh.
>
> This mview is not refreshed by the dbms_job package. The refresh procedure
> is run through cron so it's not a dbms_job issue.
>
>

Just FYI in a *correctly* set up materialized view, dbms_job would refresh the view.
Quite likely *that* is your problem: you're missing the necessary Oracle jobs.

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address