De-framentation of segments

From: Haresh Assumal <assumal_at_sprynet.com>
Date: 1998/03/20
Message-ID: <6euosl$of5$1@news3.microserve.net>#1/1

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 Fri Mar 20 1998 - 00:00:00 CST