Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Clear Rollback Informations
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