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?
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.