Re: shrink lobindex
Date: Tue, 12 Aug 2008 01:17:50 -0700 (PDT)
Message-ID: <f4a663fe-83f9-41e7-a3b2-c3d3141af304@j22g2000hsf.googlegroups.com>
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 /10.2.0.4 has fixed this issue, it has not worked for us. We upgraded to 10.2.0.4 and run shrink in Test and end up with LOB corruption.
On Aug 11, 12:27 pm, sow <marcin.s..._at_comarch.pl> wrote:
> Hi I work at 10.2.0.1 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