Max # extents reached for rollback segs

Hi,
I had encounter the below error. Can someone pls give your suggestion in order to get rid of the ora-1628 error? Tq

ORA-1628: max # extents 200 reached for rollback segment R03_HL
Failure to extend rollback segment 3 because of 1628 condition
FULL status of rollback segment 3 set.

SEGMENT_NAME MAX_EXTENTS PCT_INCREASE OWNER
--------------- ----------- ------------ ----------
SYSTEM 2147483645 0 SYS
R01_HL 200 0 SYS
R02_HL 200 0 SYS
R03_HL 200 0 SYS
R04_HL 250 0 SYS
R05_HL 200 0 SYS
R06_HL 200 0 SYS
R07_HL 200 0 SYS
R08_HL 200 0 SYS
R09_HL 250 0 SYS
R10_HL 300 0 SYS

increase the value of MAXEXTENTS

hi Slimdave,
is there any alternative beside increate the max_extents?
Tq

Hi samc,

1. Increase the NEXT parameter of the rollback segment :
ALTER ROLLBACK SEGMENT rollback_segment STORAGE (NEXT integer);

2. Increast the MAXEXTENTS storage parameter of the rollback segment:
ALTER ROLLBACK SEGMENT rollback_segment STORAGE ( MAXEXTENTS integer);

Regards,
Nir

hi,
what caused this error?

a very big transaction or import?

you can commit in between to minimise the
size of the transaction.

-Raja

Increase maxextents and specify OPTIMAL.