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 indexes and segments to new tablespace

401820Jul 16 2007 — edited Oct 25 2007

In order to re size a tablespace holding primarily LOBs, where as alter index can be used for indexes, how should one move LOBINDEX and LOBSEGMENT types? I have in my tablespace the following segment types:

SEGMENT_TYPE
---------------
LOBINDEX
LOBSEGMENT
TABLE

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 22 2007

Added on Jul 16 2007

#general-database-discussions

9 comments

2,026 views