1.select segment_name,segment_type,blocks from dba_segments
where tablespace_name='表空间'
and blocks >1
order by blocks
2.
alter table TABLENAME deallocate unused;
where tablespace_name='表空间'
and blocks >1
order by blocks
2.
alter table TABLENAME deallocate unused;