Re: Can dropping RBS cause problems?

From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Tue, 31 Aug 1999 09:11:10 -0400
Message-ID: <37CBD46E.93963284@Unforgettable.com>

"C. Payer" wrote:

> As long as I work with Oracle I often heared the question, if it could cause
> problems dropping rollback segments during normal workload (e.g. for the
> need of bigger RBS or in a different tablespace). I never had problems doing
> this, but in the technical books there is no answer to this question.
>
> But, what exactly happens with the data in the dropped RBS? Does anybody
> know an exact answer?
> Thanks, Claudia

If you are careful and methodical I don't see why you can't do it. You cannot drop a rollback segment while it is in use and as long as you always have an adequate number of rollback segments online you should be ok.

What you don't want to do is have all rollback segments offline because then the rdbms will probably try to use the SYSTEM rollback segment and that would cause real problems. Received on Tue Aug 31 1999 - 08:11:10 CDT