Originally posted by ayeleta
I have a table with lots of extents.
Check the size of this table in MB. If it is > 5M and < 160M put it on a tablespace with 5M extents.

On the otherhand, if it is > 160M put it on a tbs with 160M extents.

HTH.