Vijay,

Ur point is quite valid but just having more number of extents does not fragment a database. Normally one tends to think that it is not right to have more number of extents, rather have a single extent of a larger size- but then I ask, what is the loss? If at any point if the data is deleted, it can be reused and with LMT, u dont even need to coalesce the tablespaces.