Moving Lob Index extent (reorg tablespace)
joelsFeb 12 2008 — edited Feb 13 2008I've just shrunk my table that contains LOB. My tablespace contains only that table segment, LOB segment, and LOB Index.
After shrinking it. The LOB Index is too far seperated (almost at the end of the datafile) from the LOB segment in tablespace map view. This has made me unable to resize the datafile.
Is there any command to move that LOB Index extent back close to the rest of the extent (which are in the beginning of the datafile) ?So I can resize the datafile.
I mean beside moving the LOB Segment & LOB Index to other tablespace.
I hope my question is comprehensible.
Thanks for any response.
Joel