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));
LOG SEGMENT SHRINK SPACE
ALTER TABLE test_lob MODIFY LOB (image) (SHRINK SPACE);
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15747463/viewspace-1146209/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15747463/viewspace-1146209/