Shrinking BLOBs

For some reason altered BLOB objects may not clean up after themselves efficiently with respect to disk space and the high water mark. This is what you can do but be warned, this processing can take a very, very long time to run: alter table <table_name> enable row movement; alter table <table_name> modify lob(report) (shrink …