Size of Rollback Segment

[MJP]

Is there a limit on how big can a rollback segment could be? I am using oracle 8.1.7.2 on Solaris 5.7

[marist89]

Your rollback segment can be as large as you want providing you have the appropriate amount of disk space.

[sanju_dba]

Rollback segment can grow as any data segment provided Maxextents is not reached and Diskspace is available.
i.e. it can grow to a size of 166500 datafiles for a TBLSP * 34G ( on 64bit solaris ) = 5661000GB, or less than maxextents for ur Rollbacksegment ( I dont remember maxextents for Solaris ).

Thanx
Sanjay

[marist89]

MAXEXTENTS can be UNLIMITED. Again, there is no limit as long as you have enough disk space.

[julian]

Originally posted by marist89
MAXEXTENTS can be UNLIMITED. Again, there is no limit as long as you have enough disk space.

I wonder why when MAXEXTENTS is UNLIMITED and you extract the DDL with SQL Navigator, say for a given table, SQL Navigator sets some very large number.