Please Help with coalescing TBSs...

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. Received on Fri Mar 17 2000 - 09:32:53 CST