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