Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01562 - lack of database space???
Hi
Issueing a commit periodically may solve your problem if you
are using DML in your so called PL/SQL cursor. But if your
app needs to be commited at end then using larger rollback segment
will be the sol.
hope it help....
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
Received on Sun Nov 29 1998 - 19:50:08 CST