Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle and materialized view
Umbi wrote:
> I am having a problem with materialized views lately. We have several
> MVs and we refresh them via the DBMS_MVIEW package. Everything works
> perfectly all the week but on saturday, regularly, the refresh does not
> come back anymore. It takes days (nobody has checked how long).
> Probably some DBA tasks are running on saturday but we don't know what
> (we are not the DBAs). Can anyone suggest a reason why the refresh
> doesn't work anymore? In addition after a complete oracle restart
> everything work again perfectly.
>
> Thanks for any help,
> Umberto
>
What else runs on Saturdays, but not on weekdays?
(backups?)
-- Regards, Frank van Bortel Top-posting is one way to shut me up...Received on Mon Feb 20 2006 - 12:28:32 CST