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 segments.

just a DBAJun 18 2015 — edited Jun 18 2015

Is there a way to move only LOB segment, keeping table segment? The statement :

alter table <tab> move lob (<lob>) store as (tablespace <tbs>)

moves not only LOB segment, but also table segment, therefore consumes much resources, requires to rebuild indexes etc.

Thanks.

This post has been answered by John Stegeman on Jun 18 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 16 2015
Added on Jun 18 2015
10 comments
682 views