Re: 01555 and select statement

niy38_at_hotmail.com wrote:
> Here I feels like the before image of
>
> select * from a_big_table where some condition
>
> can not be re-construct from the rollback segment since
> many commits inside loop, then ora-01555 with SELECT
> occured

Definitely drop the incremental commits. You will likely also, as a side effect, see faster performance.

If that doesn't do it then examine undo retention as previously suggested.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org