Re: rollback segs question

From: "Larry Schenavar" >>
Can a rollback tablespace be dropped and rebuilt without any serious problems with the database? <<<

Yes, you can alter the segments offline, drop them, and re-create them. You should probably take only one rbs segment away from the system at a time.

If the Oracle instance should crash or be stopped after a segment is dropped, but before it is re-created you may need to modify the init.ora before you can restart the database if you use private rollback segments.

With version 7.3+ you can use the alter rollback segment shrink command to give up unused allocated extents. You should check to see if you have the optimal parameter set. By setting this parameter you can pretty much get Oracle to keep free extents available to whichever segment needs them.

Mark Powell -- Oracle 7 Certified DBA
- The only advice that counts is the advice that you follow so follow your own advice - Received on Wed Oct 14 1998 - 17:22:52 CDT