Re: Clear Rollback Informations

From: Neil C <btsscrth_at_bt.com>
Date: Wed, 27 Oct 1999 16:00:56 +0100
Message-ID: <7v7435$mr3$1@pheidippides.axion.bt.co.uk>

Hi,

if you are talking about clearing allocated extents for a rollback segment, then you can issue a

ALTER ROLLBACK SEGMENT x SHRINK TO zz k or
ALTER ROLLBACK SEGMENT x SHRINK TO zz m or (if you have optimal set)
ALTER ROLLBACK SEGMENT x SHRINK TO OPTIMAL

where x is the name of the rollback segment, and zz is the size in k or M you wish to shrink to.

HTH NeilC

AXK wrote in message <7v73av$j5i$1_at_nickel.uunet.be>...
>Hello,
>
>i have an Rollback Tablespace with an size 250 M, there are 200 M used.
>I have no transactions. How can i clear the Rollback Informations?
>
>Thanks for your help.
>
>Regards
>
>Axel Klos
>
>
Received on Wed Oct 27 1999 - 10:00:56 CDT