rollback segment error
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.
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)
How bout adding a COMMIT?
Call me kooky but this seems simplest.
I remember when this place was cool.
Click Here to Expand Forum to Full Width