Coalesce Index失败，为什么？？

显示全部楼层 · 2006-10-10 17:23:13

SQL>analyze index PK_CN_RPTDEFINE validate structure;
Index analyzed.
SQL>select * from index_stats;
HEIGHT BLOCKS NAME
PARTITION_NAME
LF_ROWSLF_BLKS LF_ROWS_LEN
---------- ---------- ------------------------------ ------------------------------ ---------- ---------- -----------
LF_BLK_LENBR_ROWSBR_BLKS BR_ROWS_LEN BR_BLK_LEN DEL_LF_ROWS DEL_LF_ROWS_LEN DISTINCT_KEYS MOST_REPEATED_KEY
---------- ---------- ---------- ----------- ---------- ----------- --------------- ------------- -----------------
BTREE_SPACE USED_SPACE PCT_USED ROWS_PER_KEY BLKS_GETS_PER_ACCESS PRE_ROWS PRE_ROWS_LEN OPT_CMPR_COUNT
----------- ---------- ---------- ------------ -------------------- ---------- ------------ --------------
OPT_CMPR_PCTSAVE
----------------
1
8 PK_CN_RPTDEFINE
5
1
95
7996
0
0 0
0 1
19
5
1
7996 95
2
1
2
0
0
1

18

SQL>alter index PK_CN_RPTDEFINE coalesce;
alter index PK_CN_RPTDEFINE coalesce
*
ERROR at line 1:
ORA-00439: feature not enabled: Coalesce Index

千问 · 2006-10-10 17:23:13

把 select * from v$version;的结果贴出来看一下。

千问 · 2006-10-10 17:23:13

SQL>select * from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE9.2.0.1.0 Production
TNS for Linux: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production

千问 · 2006-10-10 17:23:13

Coalesce Index 的特性需要在Enterprise Edition 中才能使用，你的数据库不是企业版。