Q: Tablespace management

I have a situation on one of our systems (Oracle 8.1.7.3). Seems there a few tables that have grown a bit. The NEXT extent for each of these tables is larger than the largest free chunk. Is there a way to adjust the NEXT on the fly (ie short of a reorg/imp/exp) to make the NEXT smaller? All the freespace chunks have been coalesed. My ultimate goal is to get these tables to thier own tablespaces but thanks to SAP they don't make it easy.

Here is the space critical report:

 04/10/2003 09:20:42 PRD sapdbci
 Critical objects checked on 04/10/2003 07:00:03

Tablespace Table       Freespace/kb         Next extent/kb   AutoExt.
                      Maximum       Total
PSAPBTABD  TST03      245,104    2,999,104    327,680            0 
PSAPBTABD  GLPCA      245,104    2,999,104    327,680            0 
PSAPBTABD  COEP       245,104    2,999,104    327,680            0 
PSAPBTABD  BSIS       245,104    2,999,104    327,680            0 
PSAPBTABD  ACCTIT     245,104    2,999,104    327,680            0 

Here is a list of the free chucks after a colaese. There are 90 or so...

	245104	
	81920(x4)
	81760	
	76160	
	71680(x4)
	71040	
	70400	
	67824	
	62080	
	61440(x2)
	60160	
	57584	
	40960(x19)
	40320	
	40280(x2)
	30720	
	25320	
	20480(x17)
	17920	
	15360	
	14080(x2)
	10240(x2)
	9600(x2)
	7680(x2)
	7040(x3)
	6880	
	5760	
	5120	
	4480	
	2400	
	1280	
	640	
	464	
	304(x2)
	144	
	112	
	104	
	80	
	40(x2)

Thanks for any help/pointers....
I am running Oracle 8.1.7 on HP-UX
Vince Received on Thu Apr 10 2003 - 10:35:53 CDT