Let say i have truncated a lot of tables which uses a tablespace, do i need to coalesce the tablespace after i truncate the tables ?
Not if you use locally managed tablespaces
"The Oracle Sponge"
Senior Manager, Business Intelligence Development
XM Satellite Radio