Hi JRPM,

I immediately coalesced the tablespace manually after droping the objects from the TS.

We have Oracle Financials Apps. So, it comes with pre-defined storage values, which is difficult to change as it is designed by Oracle. They are all dictionary managed tablespaces. I don't know whether I can change them to LMT now.

Thanks,