在oracle8.1.7下如何启用函数索引

操作过程如下：

conn sys/change_on_install@ test;

ALTER SYSTEM SET QUERY_REWRITE_ENABLED=TRUE;

系统已更改

ALTER SYSTEM SET QUERY_REWRITE_INTEGRITY=TRUSTED;

系统已更改

SHOW PARAMETER QUERY_REWRITE_INTEGRITY;

NAME TYPE VALUE

------------------------------------ ------- --------

query_rewrite_integrity string TRUSTED

show parameter QUERY_REWRITE_ENABLED;

NAME TYPE VALUE

------------------------------------ ------- ----------

query_rewrite_enabled boolean TRUE

show parameter compatible;

NAME TYPE VALUE

------------------------------------ ------- ------

compatible string 8.1.0

但是建立索引时

grant query rewrite to hmiszx;

conn hmiszx/hmiszx@ test;

create index idx_ys_worklog_estate on d_bhyb(nvl(s_bhmc,'0')) compute statistics；

还是提示：

ORA-00439: 未启用特征: Function-based indexes

[924 byte] By [msdn] at [2007-8-14 15:31:58]