Re: Defragmentation

From: Jerry Gitomer <jgitomer_at_erols.com>
Date: 2000/06/19
Message-ID: <20000619.3572000@p200.nodomain>#1/1

Sure,

		Export
		Truncate the table
		Change the initial and next values
		Import


>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 6/12/00, 1:52:24 AM, mpinzuti_at_virgilio.it ("marco pinzuti") wrote regarding Defragmentation:

> I know there exist two possibilities for solving tables fragmentation

on Oracle:
> 1- Drop the table and create it again with a better INITIAL value in
the storage clause
> 1- Perform an alter table by increasing the NEXT clause for the
following extents

> Is there anyone knowing one more method for solving fragmentation of
tables besides the previous ones and to join the various small holes (or

fragments) to each other in order to get a larger and usefull fragment?

> Thanks in advance

> ============

> VIRGILIO MAIL - Il tuo indirizzo E-mail gratis e per sempre
> http://mail.virgilio.it/

> VIRGILIO - La guida italiana a Internet
> http://www.virgilio.it/

> --
> Posted from [216.163.180.10]
> via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Mon Jun 19 2000 - 00:00:00 CDT