-
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.
Jeff Hunter
-
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.
Jeff Hunter
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|