Remember this point:
For autoallocate in locally managed tablespace Oracle manages all extent allocation and sizing automatically, based on whatever value is specified for the initial extent. So the next extent is always the same as initial extent.
Regarding your problem, to allocate the extent to an object, the extents should be adjacent. To acheive this, you can coalesce adjacent free space as follows:
ALTER TABLESPACE Z COALESCE;




Reply With Quote