Newsletters Archive - 2009

If you would like to know more about the iDevelopment.info 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
jhunter@idevelopment.info
http://www.idevelopment.info
----------------------------