Oracle分区表shrink,Oracle空间回收shrink表

分区表收缩

进行shrink space时 发生ORA-10631错误.shrink

space有一些限制.

在表上建有函数索引(包括全文索引)会失败。

exec dbms_stats.gather_table_stats(user,'PTABLE

',estimate_percent=>100);

analyze table PTABLE compute statistics;

分区表的查询 BLOCKS

select t3.table_name,

t3.partition_name,t3.high_value,t3.num_rows,t3.blocks,t3.empty_blocks,t3.last_analyzed

from dba_tab_partitions t3 where t3.table_name='PTABLE' order by

t3.num_rows desc

【进行删除数据的测试】

DELETE FROM SCOTT.PTABLE WHERE GG1DM='07' AND SL<=50

删除PTABLE1_SUB1里面的数据

analyze table PTABLE compute statistics; 进行统计信息的更新；

然后查看此时子分区的高水位线情况

select

t3.partition_name,t3.subpartition_name,t3.high_value,t3.num_rows,t3.blocks,t3.empty_blocks,t3.last_analyzed

from dba_tab_subpartitions t3 where t3.table_name='PTABLE' orde