Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: snapshot too old
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. Received on Thu Feb 26 2004 - 02:26:45 CST