MOVE 包含LOB的表

Alter table owner.table_name move tablespace tablespace_name;

普通MOVE 表的语句并不能MOVE LOB SEGMENT

MOVE LOG SEGMENT的方法是:

非分区表

Alter table_name move lob(lob_column) store as (tablespace tablespace_name) ;

分区表

ALTER TABLE current_table MOVE PARTITION partition_name

TABLESPACE destination_table_space

LOB (column_name) STORE AS (TABLESPACE lob_destination_tablespace);

注意：

MOVE LOGSEGMENT的同时 LOG INDEX会自动随着LOG SEGMENT移动不能单独LOG INDEX

LOG SEGMENT断扩充空间

非分区表

ALTER TABLE
MODIFY LOB () (allocate extent (size ));

分区表

ALTER TABLE jmjkk.HC_DATASET_PHOTO

MODIFY partition P_410103 LOB (PHOTO) (allocate extent (size 100M));

ALTER TABLE test_lob MODIFY LOB (image) (SHRINK SPACE);