failed to extend rollback for a simple select?????

From: Scott Mattes <smattes_at_erols.com>
Date: Thu, 15 Jul 1999 10:59:20 -0400
Message-ID: <378DF748.A69ACE51@erols.com>

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 Received on Thu Jul 15 1999 - 09:59:20 CDT