Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01555 on source database for materialized view refresh across link
Daniel Fink wrote:
> In the 3 hours leading up to the latest occurrence, there were only
> 1800 transactions total, using less than 600 undo blocks, no
> stealing/release/reuse of undo blocks (both expired and unexpired). It
> is a time of almost no activity (when compared to normal daily
> processing).
>
> This is what makes the error so odd.
>
> Regards,
> Daniel Fink
As there is no possible harm in it increase the undo retention and see what happens.
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Tue Jan 24 2006 - 11:44:44 CST
![]() |
![]() |