Re: Snapshot too old error with LOB Data
From: onedbguru <onedbguru_at_yahoo.com>
Date: Wed, 11 Apr 2012 18:36:34 -0700 (PDT)
Message-ID: <11751006.289.1334194594938.JavaMail.geo-discussion-forums_at_vbbfj25>
On Wednesday, April 11, 2012 9:05:33 PM UTC-4, zigz..._at_yahoo.com wrote:
> I am on Oracle 10.2.0.4 on HP UNIX.
> 1. I have a table with CLOB column:
> ORA-29903: error in executing ODCIIndexFetch() routine
> ORA-20000: Oracle Text error:
> ORA-01555: snapshot too old: rollback segment number with name "" too small
> ORA-22924: snapshot too old
> 29903. 00000 - "error in executing ODCIIndexFetch() routine"
> *Cause: The execution of ODCIIndexFetch routine caused an error.
> *Action: Examine the error messages produced by the indextype code and
> Take appropriate action.
Date: Wed, 11 Apr 2012 18:36:34 -0700 (PDT)
Message-ID: <11751006.289.1334194594938.JavaMail.geo-discussion-forums_at_vbbfj25>
On Wednesday, April 11, 2012 9:05:33 PM UTC-4, zigz..._at_yahoo.com wrote:
> I am on Oracle 10.2.0.4 on HP UNIX.
> 1. I have a table with CLOB column:
> ORA-29903: error in executing ODCIIndexFetch() routine
> ORA-20000: Oracle Text error:
> ORA-01555: snapshot too old: rollback segment number with name "" too small
> ORA-22924: snapshot too old
> 29903. 00000 - "error in executing ODCIIndexFetch() routine"
> *Cause: The execution of ODCIIndexFetch routine caused an error.
> *Action: Examine the error messages produced by the indextype code and
> Take appropriate action.
Did you not like the answer that was given in forums.oracle.com yesterday?
https://forums.oracle.com/forums/thread.jspa?threadID=2374381&tstart=0 Received on Wed Apr 11 2012 - 20:36:34 CDT