shrink lobindex
From: sow <marcin.sowa_at_comarch.pl>
Date: Mon, 11 Aug 2008 04:27:03 -0700 (PDT)
Message-ID: <05d70d35-f9a5-405c-b0dd-653f029df03f@f63g2000hsf.googlegroups.com>
Date: Mon, 11 Aug 2008 04:27:03 -0700 (PDT)
Message-ID: <05d70d35-f9a5-405c-b0dd-653f029df03f@f63g2000hsf.googlegroups.com>
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 Mon Aug 11 2008 - 06:27:03 CDT