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
Mladen Gogala wrote:
> Contrary to the popular opinion, size does matter. If you set
> UNDO_RETENTION to 3 days, Oracle will try protecting undo blocks
> for 3 days before allowing you to reuse them. In order for that
> war on ORA-1555 to succeed, you must have enough fresh blocks so
> that the previously used blocks are kept in the frig for 3 days.
> That's how size comes into the play.
I meant just for testing purposes to see if it eliminates the problem. Certainly there would be an impact in just making it larger without any other thought.
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Wed Jan 25 2006 - 11:09:05 CST