Re: Snapshot too old error with LOB Data

From: onedbguru <>
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, wrote:
> I am on Oracle 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 yesterday? Received on Wed Apr 11 2012 - 20:36:34 CDT

Original text of this message