Hi,
After you moved the segment you should use
Code:
   
   ALTER TABLESPACE ... COALESCE
to get larger peces of free blocks.

But there could still be a lot of free-spaces which are under 10M and so you cannnot use them.

Move ALL segments to another tablespace and then coalesce it.
So you will be successfull.

And in future pleas use LOCAL manged Tablespaces so this problem will never arise.


Orca