不会啊,我测试时索引空间也是释放的。我用的是8.1.6
SQL> create index idx_t_ls on t_ls(telno);Index createdSQL> select bytes,segment_name from user_segments where segment_name like '%T_LS'; BYTES SEGMENT_NAME
---------- -------------
20971520 T_LS
31457280 IDX_T_LSSQL> truncate table t_ls;Table truncatedSQL> select bytes,segment_name from user_segments where segment_name like '%T_LS'; BYTES SEGMENT_NAME
--------- --------------
65536 T_LS
65536 IDX_T_LS是否你建索引时指定了较大的初始段值?
SQL> create index idx_t_ls on t_ls(telno);Index createdSQL> select bytes,segment_name from user_segments where segment_name like '%T_LS'; BYTES SEGMENT_NAME
---------- -------------
20971520 T_LS
31457280 IDX_T_LSSQL> truncate table t_ls;Table truncatedSQL> select bytes,segment_name from user_segments where segment_name like '%T_LS'; BYTES SEGMENT_NAME
--------- --------------
65536 T_LS
65536 IDX_T_LS是否你建索引时指定了较大的初始段值?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货