When we had this problem we took the rollback segments offline (one at a
time), dropped them, then recreated them with the new storage parameters.
It worked fine - we have 10 rollback segments so the users didn't miss the
offline one. You could create a new segment with the desired storage
parameters, bring it on line, then drop the others one at a time, since you
only have 4. If this will blow your tablespace you can add another
datafile, assuming you have the disk space.
kgsudhi_at_my-dejanews.com wrote in article <7hr901$t3f$1_at_nnrp1.deja.com>...
> Thank You Rich.
> This is a 24x7 LIMS System. An Export/Import may need a 6-8 Hrs
> downtime. Is there any other method so that I can compress the extents
> to one? Can I change the table's storage parameters with out dropping
> it?
>
Received on Wed May 19 1999 - 09:19:20 CDT
