操作过程如下:
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
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
select * from v$option确认一下
Function-based indexes FALSE
好人做到底,请问我该如何安装呢?