Re: De-framentation of segments

From: Rachel Carmichael <rachel.carmichael_at_citicorp.com>
Date: 1998/03/23
Message-ID: <35165DC6.AEEFA53F@citicorp.com>#1/1

Haresh Assumal wrote:

> I have a simple question that about database defragmentation of segments in
> Oracle 8.0.3.0 on NT4.0.
>
> I got the following error when trying to insert about 60K rec into a table:
> ORA-01562: failed to extend rollback segment number 4
> ORA-01628: max # extents (121) reached for rollback segment RB2
>
> I increased the number of max number of segments and that go rid of the
> problem. My question is could I have gotten around the error by
> de-fragmenting the segment? If so how do I find out if the data is
> fragmented and how do I de-fragment it?
>
> Thanks for your help.
> Haresh
> e-mail: assumal_at_sprynet.com
Received on Mon Mar 23 1998 - 00:00:00 CST