Re: ORA-01562 - lack of database space???

Hi
Make sure you are increasing the size of tablespace containing your rollback segments.

You may or may not have sufficient space in the rollback tablespace.if you have sufficient space then you are getting this error b'cos the space has been acquired by other rollback segments and they needs to be shrunk.

shrink all the other rollback segments by issuing alter rollback segment rb1 shrink 100k;

and set the optimal for other rollback segments to a value so that space can be
automatically reclaimed but deciding the optimal value can be little tricky. if you don't want to doit then you have to shrink them manually.

create a large rollback segment (rb3) say with initial 3m and next 2m and max. the
maxextents for this rollback segment fairly large.

now you can issue a
SET TRANSACTION USE ROLLBACK SEGMENT RB3 before running your query so that the particular rollback segment is used by your transaction.

hope this helps.

sudershan

CONSULTING DBA 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 Sat Nov 28 1998 - 20:36:48 CST