I think generally as a matter of convenience to you. I have noted that everytime a new DBA comes in he wishes to either increase the number of tablespaces from 5 to 40 or reduce them from 40 to 5. Management is impressed and it keeps him busy for a day or so. We also did it to change some dictionary managed tablespaces to locally managed. If your disks are managed properly you should haven't any performance reason to do so. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Yadavalli Aditya Sent: Wednesday, May 31, 2006 9:02 AM To: oracle-l@xxxxxxxxxxxxx Subject: Tablespace reorganisation Hi Everyone, How can we know that a tablespace needs to be reorganised....? I appreciate your responce. Regards, Yadavalli.