我在user1下创建基于substr(to_char(tf_1),7,3)的索引,语句如下:
Create Index Ind_tb_1_tf_1_func
On user1.tb_1(substr(to_char(tf_1),7,3))
Initrans 8
Pctfree 2
Local
Store In (ts_indx)
Storage ( Initial 1M Next 1M Minextents 1 Maxextents Unlimited Pctincrease 0
Freelists 8 Freelist Groups 2)
Nologging
Compute Statistics
Parallel ;ORA-01031: insufficient privileges
在创建之前,已由system帐号给user1授权:
grant connect,resourct to user1;
grant unlimited tablespace to user1;
grant create any index,QUERY REWRITE to user1;user1能创建B-tree, Bitmap索引.参数文件相关参数设置如下:
QUERY_REWRITE_INTEGRITY = TRUSTED
QUERY_REWRITE_ENABLED = ENFORCE
COMPATIBLE = 8.1.0.0.0有哪位高人知道原因吗?
Create Index Ind_tb_1_tf_1_func
On user1.tb_1(substr(to_char(tf_1),7,3))
Initrans 8
Pctfree 2
Local
Store In (ts_indx)
Storage ( Initial 1M Next 1M Minextents 1 Maxextents Unlimited Pctincrease 0
Freelists 8 Freelist Groups 2)
Nologging
Compute Statistics
Parallel ;ORA-01031: insufficient privileges
在创建之前,已由system帐号给user1授权:
grant connect,resourct to user1;
grant unlimited tablespace to user1;
grant create any index,QUERY REWRITE to user1;user1能创建B-tree, Bitmap索引.参数文件相关参数设置如下:
QUERY_REWRITE_INTEGRITY = TRUSTED
QUERY_REWRITE_ENABLED = ENFORCE
COMPATIBLE = 8.1.0.0.0有哪位高人知道原因吗?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货