shrink lobindex

From: sow <>
Date: Mon, 11 Aug 2008 04:27:03 -0700 (PDT)
Message-ID: <>

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 Mon Aug 11 2008 - 06:27:03 CDT

Original text of this message