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?????
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.
Received on Thu Jul 15 1999 - 12:30:21 CDT