Fragmentation issue. You may not have a free space segment large enough to
accommodate that index extension: try running the following to see
the free space allocations
select 'freespace' owner, ' ' object,
file_id, block_id, blocks, bytes bytes
from sys.dba_free_space
where tablespace_name = upper('YOUR_TABLESPACE)
union
select substr(owner, 1, 15),
substr(segment_name, 1, 31),
file_id, block_id, blocks, bytes bytes
from sys.dba_extents
where tablespace_name = upper('YOUR_TABLESPACE')
order by 3, 4
>
Received on Fri Jul 09 1999 - 10:01:59 CDT
