Newsletters Archive - All

If you would like to know more about the Newsletter, please email me.

  Reclaiming Unused LOB Space in Oracle — (09-September-2009)

Manually reclaiming unused space in a normal Oracle table is a fairly simple 
process and can be performed online starting with Oracle 10g R1.

What if, however, the table contains a LOB column that contains significant 
unused space? Starting with Oracle 10g R2, Oracle provides a solution that 
allows users to reclaim LOB space (LOB data and LOB index) and that is the topic 
of the following recently published article:

Reclaiming Unused LOB Space in Oracle

Jeffrey M. Hunter, OCP
Sr. Database Administrator