SHRINK clause is not supported for this segment
ALTER TABLE ... SHRINK SPACE 命令无法在此段上使用。SHRINK 需要启用行移动且段使用 ASSM(自动段空间管理)。
SELECT tablespace_name, segment_space_management FROM dba_tablespaces WHERE tablespace_name = 'TBS_NAME';SELECT table_name, row_movement FROM dba_tables WHERE table_name = 'TABLE_NAME';SELECT segment_name, bytes/1024/1024 mb FROM dba_segments WHERE segment_name = 'TABLE_NAME';