ORA-01562: failed to extend rollback segment number 0 ,help!

Question

SQL> select segment_name,segment_id,MAX_EXTENTS from DBA_ROLLBACK_SEGS;SEGMENT_NAME                   SEGMENT_ID MAX_EXTENTS
------------------------------ ---------- -----------
SYSTEM                                  0         505
RBS0                                    1        4096
RBS1                                    2        4096
RBS2                                    3        4096
RBS3                                    4        4096
RBS4                                    5        4096
RBS5                                    6        4096
RBS6                                    7        4096已选择8行。已用时间:  00: 00: 00.50SQL> alter rollback segment rbs0 storage(maxextents unlimited);重算段已修改。已用时间:  00: 00: 00.20
SQL> select segment_name,segment_id,MAX_EXTENTS from DBA_ROLLBACK_SEGS;SEGMENT_NAME                   SEGMENT_ID MAX_EXTENTS
------------------------------ ---------- -----------
SYSTEM                                  0         505
RBS0                                    1       32765
RBS1                                    2        4096
RBS2                                    3        4096
RBS3                                    4        4096
RBS4                                    5        4096
RBS5                                    6        4096
RBS6                                    7        4096已选择8行。已用时间:  00: 00: 00.40
SQL>

Answer 1

SEGMENT_NAME                         SEGMENT_ID    MAX_EXTENTS   STATUS
---------------------------------    ----------   -----------   ----------------
SYSTEM                                      0       121        ONLINE
R01                                         2    2147483645    OFFLINE
R02                                         3    2147483645    OFFLINE
R03                                         4    2147483645    OFFLINE
R04                                         5    2147483645    OFFLINE这是我机器上查询结果，请赐教

Answer 2

alter rollback segment SYSTEM  storage(maxextents unlimited);
建议不要用SYSTEM的回滚段
如果OFFLINE的几个回滚段可以正常使用
建议 将alter rollback segment R01 online;

Answer 3

请问，那个MAX_EXTENTS 的计量单位是什么

Answer 4

同意  wfeng7907(无风)。