Re: snapshot too old

x wrote:
> The other workaround (if you really need to commit after 2500 rows) is to
> declare cursor like this
>
> cursor c1 is select ssn from test_table order by 1;
>
> This will keep the cursor in temp segment, not in rollback segment.
>
> But, generally, don't 'fetch across commit', or in normal language don't
> commit inside loop.
>
> And don't use larger rollback segments, since it won't solve your problem.

Could you please find a single document supporting any of your statements from:

otn.oracle.com
tahiti.oracle.com
docs.oracle.com
asktom.oracle.com

or any other reputable source?

There is not a single sentence above that appears to be valid.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)