RE: If you didn't know: ilearning.oracle.com

Shrinking the system rollback segment.

During the migration of my 7.3.4 database to 8.1.5, I ran out of max_extents in my system rollback segment. I went to Metalink to look up the error and it told me to try increasing max extents for the rollback segments (was already set to max of 249), to increase next extent size in system rollback segment (which I did), to set optimal on rollback segment system to null (which I did), to add a datafile to the system tablespace (which I doubled), and to shrink the system rollback segment using the alter rollback segment system shrink command. I did that but I still have 249 extents. The shrink command did not seem to do anything. I don't know why. I shut down the database and restarted it and tried the shrink again to no avail. I still have 249 extents. How do I get the system rollback segment to shrink?

Thanks for any ideas or thoughts, Received on Mon Nov 13 2000 - 14:53:07 CST