Forum OpenACS Q&A: Re: RBS tablespace has grown way beyond acceptable limits

Posted by Andrew Piskorski on
Bruno, you don't really want to use the default RBS tablespace because (at least be default in 8.1.x) it is a dictionary managed tablespace. Instead what you want is to create new rollback segments in a new locally managed tablespace, then drop the old RBS tablespace afterwards. See the section "Adding More Rollback Space" in my Oracle docs for all the steps on how to do this.