Blog
The Café Database Blog
How to defrag the entire contents in a tablespace
It happens. Sometimes segments grow up and fill the entire tablespace. Maybe you want to shrink the tablespace and there is something stored at the end of the file.
Yes, this is what you may do: move all segments to a new empty tablespace and “defrag it all”