2021-04-08 Oracle通过MOVE表的方式来降低高水位并重建索引收集统计信息

1.查出要MOVE表的OWNER,TABLE_SPACE,TABLE_TYPE

select segment_type,segment_name,owner,tablespace_name from dba_segments where segment_name = '';

2.确定move到原表空间or其他表空间之后move

//分区表的move
select 'alter table '
    ||table_owner
    ||'.'
    ||table_name
    ||