Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: materialized view not refreshing
DBMS_JOB never refreshed the view correcty. We abandoned trying to use it
and ran it through cron instead. Cron worked fine for a year, up until last
week.
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:uetdlq3bk5em88_at_corp.supernews.com...
>
> "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
>
>
>
Received on Fri May 31 2002 - 10:38:01 CDT