我用scott用户登录,为它的列ename创建如下索引:
create index i_emp_ename on emp(lower(ename));
抛出权限不足的错误,错误如下:
ORA-01031: insufficient privileges
请高手帮忙告诉我是怎么回事?
create index i_emp_ename on emp(lower(ename));
抛出权限不足的错误,错误如下:
ORA-01031: insufficient privileges
请高手帮忙告诉我是怎么回事?
grant create any index to scott;
不行再试这个
grant query rewrite to scott;
和
alter user scott quota unlimited on tablespacename;