Shrink table with LOB column
783262Dec 10 2010 — edited Dec 10 2010Hello,
I have a table with 1.000.000 BLOB records. I updated almost a half of the records with NULL. Now I try to reclaim the free space using:
ALTER TABLE table MODIFY LOB (column) (SHRINK SPACE);
It's still running from some time, but what I am surprised about is that this operation generates a lot of redo logs (the full table had 30Gb, after the update it should have 15Gb, and by now I already have about 8Gb of generated archive logs).
Do you know why this operation generates redo logs?
Thank you,
Adrian