Re: ORA-01562

Norman Dunbar wrote:
>
> Unlimited extents on a rollback segment is not a good idea !
>
> <QUOTE>:
> 8. Rollback segments have an internal maximum of 32767 extents.
> Attempting to extend a rollback segment beyond this may result in
> internal errors and corruption (See Bug:671491)
> </QUOTE>

At least in 8.1.7.2.0 (Solaris, BS=8k) you can try to set the maxextents for a rollback segments to unlimited but it will stay at 32765.

SQL> select MAX_EXTENTS, SEGMENT_NAME from dba_rollback_segs;

MAX_EXTENTS SEGMENT_NAME

----------- ------------------------------
        505 SYSTEM
      32765 RBS0

SQL> alter rollback segment RBS0 storage (maxextents unlimited);

Rollback segment altered.

SQL> select MAX_EXTENTS, SEGMENT_NAME from dba_rollback_segs;

MAX_EXTENTS SEGMENT_NAME

----------- ------------------------------
        505 SYSTEM
      32765 RBS0

Regards,

Knut Received on Wed Jun 19 2002 - 08:30:05 CDT