There is a big database and we are having issues with space. I want to reclaim unused space from segments.
a) What query can i perform that shows unused space of segments ?
b) I will like to know how to reclaim unused space from these different type of segments :Tables, Indexes,Lob Index,Lob Partition, Lob Segments.
c) How to reclaim space from LOB Columns.