rollback segment error

[sri_dba]

Hi All,

Can anyone help me in this issue.

I got the following error when i run a big process.

ORA-01562: failed to extend rollback segment number 11
ORA-01628: max # extents (121) reached for rollback segment RB10.

can i increase the data file size on rollback segment table space.

Please help me.

[pando]

it says maxextents...

[gbrabham]

I would create a LARGE rollback segment and prior to running the
large transaction ... set the transaction to use the large rbs instead
of extending the smaller rollback segment to death ...

sql> set transaction use rollback segment large_rollback_segment_name

Otherwise ... as Pando says ... Set the maxextents for the rollback
segments to unlimited (if you can't set the rollback segment as
shown above ... you'll get whatever one Oracle will give you)

HTH
Gregg

[Mr.Hanky]

How bout adding a COMMIT?

Call me kooky but this seems simplest.

MH