The Café Database Blog

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”