Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Please Help with coalescing TBSs...
Sonya,
The ALTER TABLESPACE COALESCE command just coalesces fragmented, adjacent free space. For instance, if the tablespace is fragmented as such:
table1
table2
free
free
table2
free
table1
and you issue the ALTER TABLESPACE COALESCE, then you should get something like:
table1
table2
free
table2
free
table1
Only the two adjacent free space chunks are coalesced into one bigger chunk. Note that tables 1 & 2 are not coalesced. For that, you'll need to do something like EXPORT/IMPORT, or CREATE TABLE AS SELECT.
HTH,
Brian
tandym_at_hotmail.com wrote:
>
> I need to coalesce some tablespaces in our production database, I have
> issued the 'alter tablespace my_tbs coalesce' command (in sqlplus, on a
> little used TBS), yet the graphical representation of the tablespace
> pictured in tablespace manager remains the same as before. Is this
> normal? Should the picture look different, or did the coalesce simply
> make the free space known to the database, but didn't alter the way the
> file is arranged? I admit I am ignorant - but in the books I have
> looked, I cannot find the 'coalesce' parameter listed in any of
> the 'alter tablespace' syntax listings.
>
> thanks.
>
> sonya
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
--