Re: Snapshot too old error with LOB Data

From: joel garry <joel-garry_at_home.com>
Date: Thu, 12 Apr 2012 08:54:21 -0700 (PDT)
Message-ID: <48375dd8-cf3e-4309-904f-9c818e4afbf0_at_v17g2000pbt.googlegroups.com>

On Apr 11, 6:36 pm, onedbguru <onedbg..._at_yahoo.com> wrote:
> 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

I didn't like the answer given yesterday. The doe snot typo cracked me up.

jg

--
_at_home.com is bogus.
Debra Lilley, president of the UKOUG, said that the opportunity to
quiz Kyte was one "that does not come along often".
http://www.computerworlduk.com/news/infrastructure/3350626/oracle-database-guru-tom-kyte-answers-your-sql-questions/

Received on Thu Apr 12 2012 - 10:54:21 CDT