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

Collapse
1: RBS tablespace has grown way beyond acceptable limits
Posted by Bruno Mattarollo on 01/17/04 02:15 PM

Hello,

In our development instance, the RBS tablespace from Oracle 8i has grown to 2GB and I want to resize it to claim back some space on the disks but I am having the problems as mentioned in this old Web/DB post... Is there another way instead of dropping the tablespace and re-creating it?

Thanks in advance,

Bruno

Collapse
2: Re: RBS tablespace has grown way beyond acceptable limits (response to 1)
Posted by Andrew Piskorski on 01/18/04 01:46 PM
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.