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);