Re: can not be coalesced

What version of Oracle are you running? What is the percent increase set to for the tablespaces you are trying to coalesce?

Yi Zhang <yzhang_at_cv.net> wrote in message news:<3B60B6FD.807A73B5_at_cv.net>...
> Hi:
>
> alter tablespace RBS coalesce;
> It doesn't work. they looks not be contigous.
> Do I have some way to coalesce them instead of way of
> export->drop->create->import?
> Thanks!
>
> -Roy
>
> SVRMGR> select * from dba_free_space where tablespace_name='RBS' order
> by block_id;
> TABLESPACE_NAME FILE_ID BLOCK_ID BYTES
> BLOCKS RELATIVE_F
> ------------------------------ ---------- ---------- ----------
> ---------- ----------
> RBS 3 770 1572864
> 192 3
> RBS 3 1602 1048576
> 128 3
> RBS 3 1794 2097152
> 256 3
> RBS 3 2882 1572864
> 192 3
> RBS 3 3394 524288
> 64 3
> RBS 3 3714 2621440
> 320 3
> RBS 3 4162 33030144
> 4032 3
> RBS 3 8322 524288
> 64 3
> RBS 3 8578 524288
> 64 3
> RBS 3 8898 516096
> 63 3
Received on Mon Jul 30 2001 - 19:47:11 CEST