Re: Fetching across commits

[Shankar <ushash01@SHAFIKA.VETRI.COM>]

Dan
    According to my view it is purely an ORACLE Error ,
    If You are running Transaction , which is Not Commited  For e-g

In one end you are Updating a Table with huge data , and in other end you are
selecting the Data of the same Table, then
the Rollback Segment should be capable of holding both the Values ( Records
before Updation & Records before selection )
being the case the Selection which is after the Updati

So in that case you can overcome the Problem in both ways :

    1) Increase the size of the Rollback Segment , and Set the Particular RS to
the Transaction.
    2) Commit the Changes immed..

Thanks


"Johnson, Dan" wrote:

> Hi All,
>         We are currently experiencing the Oracle 1555 error, or Snapshot too
> old: Rollback segment with name xxx too small. We know that this error can
> occur if you are fetching across commits, can anyone tell me if this is done
> by SQR as a default or if it must be specified by the programmer.
>
> Thanks for any help.
> Dan Johnson
> Programmer/Analyst
> Wright Express Corp