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
Printable View
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
Your rollback segment can be as large as you want providing you have the appropriate amount of disk space.
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
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.Quote:
Originally posted by marist89
MAXEXTENTS can be UNLIMITED. Again, there is no limit as long as you have enough disk space.