delete from tablename
truncate table tablename
alter table tablename move;
alter index myIndex rebuild ;
analyze table tablename compute statistics
analyze table tablename delete statistics ;
SELECT t.tablespace_name, round(SUM(bytes / (1024 * 1024)), 0) ts_size
FROM dba_tablespaces t, dba_data_files d
WHERE t.tablespace_name = d.tablespace_name
GROUP BY t.tablespace_name;
查看表空间
select segment_name, bytes / 1024 / 1024, s.*
from user_segments s
where segment_type = 'TABLE'
order by bytes desc;
查看表占用资源