Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: failed to extend rollback for a simple select?????
we were single stepping through the code one line at a time and it was
on the first time through.
tedchyn_at_yahoo.com wrote:
>
> scott: how many times pl/sql code blocks were executed ? If it is in a
> loop, this can get execute many times.
> Ted chyn
> In article <378DF748.A69ACE51_at_erols.com>,
> Scott Mattes <smattes_at_erols.com> wrote:
> > Oracle 8.05.?
> > Merant (was MicroFocus) Toolbox 4.1
> > IBM AIX
> >
> > I didn't know that you needed rollback segments for a select?
> >
> > select field1
> > into :field1
> > from table1
> > where field2 = :field2
> >
> > causes about a 20-30 second delay and then a "failed to extend
> rollback
> > segment x" message.
> > But doing the following
> >
> > select field1
> > from table1
> > where field2 = 'value'
> >
> > from SQLPlus runs just fine and returns the one record we thought we
> > should get.
> > ---------------------------------
> > Scott Mattes
> > Work: Scott.Mattes_at_Wang.com
> > Home: SMattes_at_Erols.com
> > Web: www.erols.com/smattes
> >
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
--