Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01562 - lack of database space???
You need bigger rollback segments or you need to commit more often.
In article <73q7b8$9j8$1_at_winter.news.rcn.net>,
<agibbons_at_erols.com> wrote:
> Can anyone suggest a course of action? Oracle 7.x, Forms 4.x
>
> I have a data entry form with a WHEN-BUTTON-PRESSED trigger which
> executes several long processing PL/SQL cursors. At about 3/4 of the way
> through the long transaction I receive the following error:
>
> ORA-01652 - failed to extend rollback segment
> (no further info. is provided)
>
> I have tried extending tablespaces in the database to see if this corrects
> the problem. However, the ORA error message is still received at the
> same point in the transaction when it is run again.
>
> The Server Messages manual says 'lack of space in the database'...
>
> Should I keep on increasing the tablespace sizes (now getting rather large
> and
> pretty empty) or does the solution lie elsewhere?
>
> Thanks in advance,
>
> AEG
>
>
--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Nov 30 1998 - 14:49:17 CST