Wednesday, September 29, 2010

UNDO Data for a LOB Segment is Kept within the LOB Segment Space

Never realized this before. See metalink note:
How to determine the actual size of the LOB segments and how to free the deleted/unused space above/below the HWM [ID 386341.1] for details.

Using command to free the space:
alter table <tablename> modify lob(<lob_column>) (shrink space [cascade]);

No comments:

Post a Comment