Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Moving Lob Index extent (reorg tablespace)

joelsFeb 12 2008 — edited Feb 13 2008
I'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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 12 2008
Added on Feb 12 2008
5 comments
1,105 views