1-查看oracle分区表空间占用情况:
select partition_name,segment_type,bytes/1024/1024 from user_segments where segment_name ='MT_MSG';
2-使用truncate命令删除分区表占用的表空间
SQL> alter table MT_MSG TRUNCATE PARTITION TBL_DAY07 update global indexes;
TBL_DAY07--分区表表名
1-查看oracle分区表空间占用情况:
select partition_name,segment_type,bytes/1024/1024 from user_segments where segment_name ='MT_MSG';
2-使用truncate命令删除分区表占用的表空间
SQL> alter table MT_MSG TRUNCATE PARTITION TBL_DAY07 update global indexes;
TBL_DAY07--分区表表名
转载于:https://my.oschina.net/u/1255588/blog/1579699