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!

Move lobsegment failed due of space required

mikyOct 5 2025

In Oracle Database 19:

Tried to move a 300GB basicfile lobsegment as

ALTER TABLE owner.table_name MOVE LOB(column_name) STORE AS basicfile (TABLESPACE tbs_name) logging;

but during moving I observed temporary segment in tbs_name reached 450GB and space exahusted

So why move required a temporary segment bigger than lobsegment size ?

Comments
Post Details
Added on Oct 5 2025
9 comments
85 views