Re: ORA-01653: Unable to extend table

To see if it is a coalescing problem you can execute the following query:

select tablespace_name, percent_blocks_coalesced from dba_free_space_coalesced
where percent_blocks_coalesced < 100
order by percent_blocks_coalesced

if you have any tablespaces show up, execute this statement for each tablespace. alter tablespace <tablespace_name> coalesce

The SMON process will automatically coalesce tablespaces unless the pct_increase parameter for that tablespace is set to 0. If the tablespaces are not coalesced then it is possible for free space to be fragmented enough to prevent the system from obtaining an contiguous section of space.

Paul

In article <370112DD.6693B275_at_ix.netcom.com>,   gremlin <gremlinNO__SPAM___at_ix.netcom.com> wrote:
> I'll recheck, but I think it is OK. For the 2 tables that share the
> same tablespace, one has free blocks, the other (bigger records) does
> not. Is this a coalescing problem or something?
>
> Thanks
> Mike
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Mar 31 1999 - 09:28:30 CST