> 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?
Nothing. Data disapeared. When you will want to rollback any transaction
from this segment, probably you'll receive 'snapshot too old" error or
someth.
Received on Tue Aug 31 1999 - 07:59:25 CDT
