This discussion is archived
7 Replies Latest reply: Feb 28, 2013 12:40 AM by Richard Harrison . RSS

Space Reclaiming and Re-Organization for Tablespace

724584 Newbie
Currently Being Moderated
Hi Experts

I have one Database running on 10.2.0.4 EE. This DB has grown very fast in last few months because of loads of loads of data being populated into it.

Few weeks back we purged some big tables from a tablespace roughy 700GB data was purged. We did truncate of some few tables. After this we tried to recover the space from tablespace which is reflecting it has 100% free space but when we check how much we can reclaim we saw most of the objects /segments are lying just before HWM. Due to this we are not able to recover the space from datafiles and as well from file system. File systems are giving alerts .

Please help to fix this issue.

I would be happy some one can start providing solutions as I have tried almost everything but no success.

Waiting for some quick responses.