Re: Tablespace defragmentation

You don't need to drp the temp tablespace to clean it up. You can create a table that is the same size as the tablespace -1 block for overhead. Then drop the table.

To clean up the index tablespace, you can drop the indexes and do the same thing, then recreate the indexes.

The only way to clean up the system tablespace is with a full import, recreate the database, and import back into the database. You should be sure that the system account is using the temp tablespace as its temp area to reduce fragmentation.

-- 
***********************************************************************


*  Gayle Masters                              glmaster_at_jol.mobil.com  *

*  Mobil Oil Corporation                                              *

*  P.O. Box 874                               Phone: +1.815.423.7780  *


*  Joliet, Illinois  60434                      Fax: +1.815.423.7726  *


***********************************************************************