Re: shrink lobindex

From: Hardik <>
Date: Tue, 12 Aug 2008 01:17:50 -0700 (PDT)
Message-ID: <>

I would go with moving LOB to the new tablespace

do NOT run the shrink command on LOB. It will corrupt your LOB data... Bug 5636728.

Although. Oracle is claiming that the patch 5636728 / has fixed this issue, it has not worked for us. We upgraded to and run shrink in Test and end up with LOB corruption.

On Aug 11, 12:27 pm, sow <> wrote:
> Hi I work at and I have problem with shrink tablespace,
> because at the end of file I have lobindex.
> So the command ALTER TABLE <table> MODIFY LOB(<column>) (SHRINK SPACE)
> doesn't make sense, because I can change only lob segment without
> index, and block_id of that index is always at the end of file.
> Advice is to move lob to the other tablespace?
> Any idea?
Received on Tue Aug 12 2008 - 03:17:50 CDT

Original text of this message