In today’s video we’ll give a demonstration of how to shrink tables that contain a lot of free space. As I say in the video, this is not something you should do regularly. It’s only necessary if you’ve done some drastic one-off maintenance, like a large data purge maybe.
There are a few articles this relates to.
- ALTER TABLE … SHRINK SPACE Command : Online Segment Shrink for Tables, LOBs and IOTs
- Online Statistics Gathering for Bulk Loads in Oracle Database 12c Release 1 (12.1)
- Reclaiming Unused Space in Datafiles
The star of today’s video is Kellyn Pot’Vin-Gorman, who is returning to her Oracle roots, but on Azure. 🙂