can not be coalesced
Date: Fri, 27 Jul 2001 00:34:46 GMT
Message-ID: <3B60B6FD.807A73B5_at_cv.net>
Hi:
alter tablespace RBS coalesce;
-Roy
SVRMGR> select * from dba_free_space where tablespace_name='RBS' order
by block_id;
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!
TABLESPACE_NAME FILE_ID BLOCK_ID BYTES
BLOCKS RELATIVE_F
RBS 3 8578 524288
64 3
RBS 3 8898 516096
63 3
Received on Fri Jul 27 2001 - 02:34:46 CEST
------------------------------ ---------- ---------- ----------
---------- ----------
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