Re: Tablespace is full ... now what??

If the tables are created and dropped, leaving the space available to be used, you could create a table that would use all of the space in the tablespace. This would defrag the tablespace. If all the tables have not been dropped, you could create tables that would use contiguous blocks. This can be identified by looking in dba_free_space.

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


*  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  *


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