Re: cannot extend RBS -- can I commit?

No
You have two alternatives
1 enlarge the rollback segment
2 split the single transaction in smaller transactions, and commit more frequently.

Hth,

--
Sybrand Bakker, Oracle DBA
Verna Legaspi <verna.legaspi_at_attws.com> wrote in message news:84gcbo$7ks$1_at_redftp.redftp.attws.com...
> Hi everyone,
>
> I think we've finally come to the "root cause" of our software upgrade
> problem that we've been fighting for months (VERY LONG story). It seems
the
> software upgrade that modifies our database is running out of RBS space.
> The error we're getting is ORA-01562 (Failed to extent rollback segment #)
&
> ORA-01628 (max # extents (121) reached for rollback segment)
>
> My question is -- can I just do some kind of "forced commit" so that it
> doesn't need all that RBS?
>
> TIA,
> Verna
>
>
>
Received on Thu Dec 30 1999 - 14:45:00 CST