Small file tablespace
Hi, I have small file tablespace in Oracle10g r2 server. In this database have executed a lot of DML operations. For example: I frequently executed insert ,update ,delete operations.. And I droped one user from database contained big tables which size was equal half of database. I think this tablespace must be defragment. How can i do it?. I know that "alter tablespace coalesce". But I am not sure that this is correct , and how is it work i do not know. What should do I?
0